Chapter 3, Problem 22RQ

Program Plan Intro

Index Table:

Index Tables are created to create index over the fields in data stores which are frequently referenced by queries. Creating indexes can improve the query performance in database by allowing applications to locate the data quickly to retrieve from a data store. This is done at the cost of additional writes and storage space to maintain the index data structure.

Index Key:

The key which is used to uniquely identify the index table is referred as Index Key. Index key can have null as its value. The index is a small database which hare sorted by key values.