Sort sequence and the CREATE INDEX statement

 

Indexes are created with the sort sequence that is in effect when the CREATE INDEX statement is run.

An entry is added to the index every time an insert is made into the table over which the index is defined. Index entries contain the weighted value for character key, and UCS-2 and UTF-16 graphic key columns. The system gets the weighted value by converting the key value based on the sort sequence of the index.

When selection is made using that sort sequence and that index, the character, or UCS-2 or UTF-16 graphic keys do not need to be converted before comparison. This improves the performance of the query.

 

Parent topic:

Sort sequences and normalization in SQL

 

Related concepts

Using indexes with sort sequence