What is an index key
Answers
Answered by
3
Answer:
The index key is a null terminated string of null terminated tokens as shown in the following example: +Col1\0-Col2\0+Col3\0\0. The key in the example may be used to create an index over three columns in the table. Each column specified in the index is referred to as the "index segment" or "key column"
Please Mark My Answer As Brainliest
Answered by
3
An index key is a column, an ordered collection of columns, or an expression on which you define an index. DB2® uses an index key to determine the order of index entries. Good candidates for index keys are columns or expressions that you use frequently in operations that select, join, group, and order data.
Similar questions