Hi Tamil,

I ran an analyze on the index:

ANALYZE INDEX index_name VALIDATE STRUCTURE;

And re-ran the query with no avail. Its very strange. Do u think a rebuild of the query will help?.