Predicates

Restriction: This topic applies to Windows environments only.

In the case of a simple predicate involving an indexed column, the XDB Server will generally use the index to speed retrieval. For example, given an index on ZIP, that index will be used to process the following query:

SELECT * FROM employee 
    WHERE zip = "20441"