How To View the Execution Plan of the Query On Oracle


If you are wondering which execution plan the query is using when you run a query, you must run the command “set autotrace on explain” before running the query.

Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *