Thanks for the responses. I cannot really replace the index as this is a live system and a very huge one, wont know what other queries will be affected if we change the order. This particular query is being run through Crystal Reports. Am testing the index hint through sqlplus and once I get it working and see an improvement, will implement it in Crystal. Worst case, have to create another index...