Thanks for quick reply. Here is my reply to check list:
#1 – Yes only desired fields are indexed & I have regenerated index table too & checked for the results. But no luck.
#2 – Yes its indeed used.
#3 – Yes its turned off.
#4 – Yes, there is no exact matching filter.
Do let me know if you need more details.