We are working on datawarehouse project with composite partitioned table on date (range) and city (list).
I also created non-unique local index same with partition key (date, city).
My question is: does it have any bad impact for the optimizer if i create the index with the partition range key at the last position of the index (city,date).
Which one better?
From what i've read, when using multicolumn index.
Its better if we put highest cardinality value first. cmiiw
Thanks in advance