Making Retrievals Faster—"Keys"

key|( This section shows you how to speed up your data retrievals by building keys for some commonly accessed columns. A key is a list of pointers to the data records of a table. The key is ordered by the values of the column for which the key is defined. Whenever Rim is performing an ``equals'' type of search, it will use the pointers to access data records, resulting in a much faster retrieval. However, updates to the table are more time consuming when columns are keyed. When possible, you should first load the table and then build any useful keys.



Subsections