SQL query guidelines

When an SQL query is passed to the ObjectServer, query optimization and query plans are used to evaluate the available methods for accessing or modifying the data, and to select the most efficient way to run the query.

The evaluation determines whether index scans or primary keys can be used, or whether a full table scan must be performed instead. If index scans are used, indexes are automatically applied to SQL queries that reference indexed columns.