Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 10th, 2009
ON table_name (column1, column2,. column_n)[ COMPUTE STATISTICS ];-- UNIQUE indicates that the combination of values in the -- indexed columns must be unique.-- COMPUTE STATISTICS tells Oracle to collect statistics during -- the creation of the index. The statistics are then used by the -- optimizer to choose an execution plan when SQL statements -- are executed.-- for example: CREATEINDEX supplier_idx
ON supplier (supplier_name);-- this example creates an index on the supplier table -- called supplier_idx.
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.