Description: When creating an index, the default method Oracle uses to sort the index is in ascending order (SORT). However, if the rows are already stored in the database in ascending order you can use the NOSORT clause to skip the sorting process. Oracle will check to make sure that this is in fact the case and will return an error if the rows aren't actually in ascending order already. Normally you should use this clause when you first create or load the table.
If neither SORT or NOSORT is provided, Oracle will use SORT as the clause.
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.