There are two interesting situations where JDataStore5 will not use an index.� These are slated to be fixed in JDataStore6

1) For composite indexes, all index columns are referenced in the where clause in order for the SQL engine to consider the index.
2) Only single column indexes will be considered for range comparisons.