Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 10th, 2009
-- syntax for creating a function-based index:CREATE[UNIQUE]INDEX index_name
ON table_name (function1, function2,. function_n)[ COMPUTE STATISTICS ];-- for example:CREATEINDEX supplier_metrics
ON supplier (UPPER(supplier_city));-- to be sure that the Oracle optimizer uses this index -- when executing your SQL statements, be sure that -- UPPER(supplier_city) does not evaluate to a NULL value. -- To ensure this, add UPPER(supplier_city) IS NOT NULL to -- your WHERE clause as follows:SELECT supplier_id, supplier_city,UPPER(supplier_city)FROM supplier
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.