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.
In most cases, an index is used to quickly locate the data record(s) from which the required data is read. In other words, the index is only used to locate data records in the table and not to return data. A covering index is a special case where the index itself contains the required data field(s) and can answer the required data.