Skip to content

Instantly share code, notes, and snippets.

@MilesDowe

MilesDowe/sql-oracle-explain.md

Last active April 5, 2018 22:21
Show Gist options
  • Save MilesDowe/a138fcac0a39e28500c073aa9b397c5e to your computer and use it in GitHub Desktop.
Save MilesDowe/a138fcac0a39e28500c073aa9b397c5e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql-oracle-explain.md
  1. Evaluate query: EXPLAIN PLAN FOR <sql query as usual>;
  2. View evaluation: SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment