Creating an Inverted Index

The inverted index (not to be confused with a Metamorph inverted index-a different type of index) is a highly specialized index, which is designed to speed up one class of query only, and as such has some limitations on its use. The primary limitation is that it can currently only be used on a field that is of the type UNSIGNED INT or DATE.

Inverted indexes can be used to speed up the ORDER BY operation in the case that you are ordering by the field that was indexed only. For maximum effect you should also have the indexed ordered in the same manner as the ORDER BY. In other words if you want a descending order, you should have a descending index.

An inverted index can be created using this command:

     CREATE INVERTED INDEX SALINDEX
     ON EMPLOYEE (SALARY) ;