Q300. How do you check whether partition pruning is happening?

Answer

Use explain plan:

EXPLAIN PLAN FOR SELECT * FROM sales WHERE sale_date=…

SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);

Look for:

• PARTITION RANGE SINGLE