How does the nosort option work when
creating an Oracle index. I tried creating an index
and noted that the number r of sorts increased by one.
Answer: The create index . . .
nosort option only works when the table rows are
already worsted into the exact same sequence as the index.
such as a sorted has cluster table, or a table which has
just been created using CTAS with an ORDER BY clause:
If a single row is found to be out of order, Oracle will
abort the ooeration with the ORA-01409:
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.