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?