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