Oracle Partition Pruning
Oracle Partition Pruning is a SQL statement in the Oracle Specific category. Oracle automatically excludes irrelevant partitions from query execution. Dramatically improves performance on large tables. The syntax is SELECT * FROM partitioned_table WHERE partition_key = value;. It returns partition-pruned query. A typical example: CREATE TABLE orders ( order_id INT, order_date DATE, amount DECIMAL ) PARTITION BY RANGE (order_date) ( PARTITION p2024 VALUES LESS THAN (DATE '2025-01-01'), PARTITION p2025 VALUES LESS THAN (DATE '2026-01-01'), PARTITION p2026 VALUES LESS THAN (DATE '2027-01-01') ); -- This query only accesses p2026: SELECT * FROM orders WHERE order_date >= DATE '2026-01-01'; -- This query accesses p2025 and p2026: SELECT * FROM orders WHERE order_date BETWEEN DATE '2025-06-01' AND… A close relative is SEQUENCE (Oracle), which oracle: generates sequential numbers. Independent of tables. Accessed via NEXTVAL and CURRVAL. A close relative is ROWNUM / FETCH FIRST, which oracle: ROWNUM assigns sequential numbers to rows. Used for limiting results (pre-12c).