Secondary indexes

Abstract: Secondary indexes

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

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

Installation & Registration Annual Agreements Single Incident Supported Versions

Discussion Forums Documentation Developer Network Bugs & Suggestions Examples Audio Audio & Video Video