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.
When to Use Function-Based Indexes. A function-based index computes the value of an expression that involves one or more columns and stores it in the index. The index expression can be an arithmetic expression or an expression that contains a SQL function, PL/SQL function, package function, or C callout. Function-based indexes also support linguistic sorts based on collation keys, efficient linguistic collation of SQL statements, and case-insensitive sorts.