Tips for improving query performance
Tips for table scan
Tips for index key positioning
Tips for parallel index key positioning
Tips for index key selection
Tips for parallel index key selection
Tips for encoded vector selection
Tips for sort sequence
Tips for grouping
Tips for nested loop join
Tips for hash join
Tips for temporary index
Tips for dynamic bitmap
For more information, see Database Performance and Query Optimization in the
Information Center
.