Key

CA Datacom/DB provides the ability to define one or more keys for a table. In DQL Mode only, keys are specially defined columns or groups of columns whose definitions are stored in the CA Datacom/DB index along with directions to the location of actual data. A group of columns can be defined as one key and is known as a compound key. Using keys to join tables means CA Dataquery users can quickly retrieve data because CA Dataquery does not read whole tables to find the locations of needed rows.