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 Link to Information center.