Hi
I have a table which is range partitioned on date field. I have created an index based on another column. When issue a query on the table, the index is not used.
Can anyone tell why the index is not used and how to make the index to be used?
thanks & regards
Arasu