Copyright Ó Oracle Corporation, 1999. All rights reserved.
10-10
Avoiding Sort Operations
Avoid
sort operations whenever possible by:
•Using NOSORT to create
indexes
•Using UNION ALL instead of
UNION
•Using index access for table
joins
•Creating indexes on columns
referenced in the ORDER BY clause
•Selecting the columns for
analysis
•Using ESTIMATE rather than
COMPUTE for large objects