Queries that Benefit from Secondary Indexes

Secondary indexes benefit queries with filter conditions, ORDER BY clause, and projections.

They benefit these query elements in the following ways:

Filter Conditions
Eliminates full table scans, reducing the number of documents that HPE Ezmeral Data Fabric Database reads, if the filtering fields are keys in an index.
Eliminates the need to sort the data after scanning the index, if the index's sort order matches the query's sort order.
Eliminates the need to read the HPE Ezmeral Data Fabric Database JSON table, if all fields referenced in the query are fields in an index.
NOTE The projections optimization is not supported for OJAI queries that execute through the OJAI Distributed Query Service, and SQL queries issued to Drill. See OJAI Distributed Query Service for details about the types of OJAI queries that use the service.

The following topics describe the specific query types and provide examples.