Structures that provide fast access to particular rows or sets of rows require that one or more columns be specified as the key of the table. The key column or columns are used to index the table. When specifying a value for this key, a partial value (the leftmost part of the key) is allowed unless the structure is hash.