Extended Functions of ASF › Creating Indexes › Fast Access Keys

Fast Access Keys

Use for Join, Select Columns

Columns that are used for joining and selecting data should be defined as fast access keys. A fast access key consists of one column, and is indexed as duplicates last, sorted in ascending order.

You can define more than one fast access key for a single table. Type x in the Fast Access Keys field for each column you want to define as a fast access key.