Managing Indexes

1.Classification of Indexes
Logical
- Single column or concatenated
The maximum number of columns in a composite key index is 32.However,the combined size of all the columns cannot exceed roughly one-third of the data block size.