Looking for the definition of SOL? Find out what is the full meaning of SOL on Abbreviations.com! 'Solution' is one option -- get in to view more @ The Web's largest and most authoritative acronyms and abbreviations resource. Login
About Indexes. Indexes are optional structures associated with tables and clusters that allow SQL statements to execute more quickly against a table. Just as the index in this manual helps you locate information faster than if there were no index, an Oracle Database index provides a faster access path to table data.
Clustered indexes are indexes where the actual data in the table is placed at least roughly in order of the index. If a clustered index exists on a table, DB2 will attempt to insert data in the order of the clustering index.ndex Types. Realistically, DB2 supports only a B-tree style of index. There are other types you might hear about like block indexes for MDC tables, but they are only used in special situations. The diagram below shows what the structure of a B-tree index looks like.