Secondary indexes

By: Ben Matterson

Abstract: JDataStroe5 will not use indexes in two situations

Usage of secondary indexes by SQL

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.

Server Response from: ETNASC03