Advertisement
thesuhu

Oracle Explain Plan

Sep 20th, 2022 (edited)
2,251
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. --- LOAD THE EXPLAIN PLAN TO PLAN_TABLE
  2. EXPLAIN PLAN FOR
  3. SELECT COUNT(*) FROM dbaclass;
  4.  
  5. --- DISPLAY THE EXPLAIN PLAN
  6. SQL> SELECT * FROM TABLE(dbms_xplan.display);
  7.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement