Hi Nikhil, You are selecting all entries with SELECT * so there is no need for the index. You need to restrict the query with a WHERE clause on the field that the index is created on for the index to be used, as Udo pointed out.
Best regards, Tommy Jeppesen Data Fabric Technical Support Engineer EMEA - Spain Email: [email protected] Mobile: +34 646 878 424 On Wed, Dec 16, 2015 at 9:57 PM, Udo Kohlmeyer <[email protected]> wrote: > 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 >
