Previous Topic Next topic Print topic


Predicates

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"
Previous Topic Next topic Print topic