Unanswered: testing various partition options
I have this table that we need to partition.
I set up 3 different environments with a different partition strategy in each environment.
I guess I am confused about the indexes on the partitioned table. With my tests, it seems that some queries take longer on one environment than anbother. However, there is no consistency between the 3 environments.
If I range partition by date, and the queries all have the date-column in their where-clauses, does that mean I definitely should use a local-partition index??
Should all indexes that have that column be local-partitioned?
you can lead someone to something but they will never learn anything ...