Hi Nikhil, >From my basic querying and database knowledge, I can only guess that the reason why the index is not used is because you are not restricting on the field you have an index on.
I don't think that ordering would use indexes. Indexes are primarily there to efficiently find objects not to sort them. --Udo
