Thanks Paul.

when doing more research on this issue, yesterday i found that there are no stats available for the index in issue. How did optimizer choose to pick the index when there is no stats available? Is this because number of output rows are very less?

I am also looking into the indexing strategy.

Thanks,