- Give priority to short-running queries over longer-running ones
- Accelerate the performance of complex analytical queries
- Reduce the amount of data scanned by queries to improve efficiency
- Improve the performance of data loading operations from external sources