I have a partitioned table which is partitioned by date field.
PK has a global index, other indexes are local indexes.
When I try to select from one of the partition and looked at the execution plan it uses a index, same query with the different date and different partition, looked the execution plan which uses a full table scan.
Also, looked at the status of the indexes, which are in usable state.
I rebuild the index and try to run the query and results were same as before (Full table scan instead of index).

Please let me know, what could be the problem....


Thanks..