Advanced SQL Developer — Hard
Key points
- Partition pruning optimizes query execution by skipping unnecessary partitions.
- It is based on query predicates to determine which partitions to scan.
- Helps in reducing I/O and improving query response time.
Ready to go further?
Related questions