Open your query there, or write the query you want to analyse. In SQL Developer, you can look at the Explain Plan (or Execution Plan) by going into the Worksheet window (where the SQL query is written). How To See The SQL Developer Execution Plan It’s a common feature in many SQL IDEs as well.

It also lets you analyse existing queries to see if they are inefficient if you’re looking for ways to improve your queries. It shows what kind of operations the database will perform, and some other statistics such as cardinality and cost (which we’ll get into later).Īs someone writing a query, it gives you an idea of how the query will run and shows you if a query is inefficient before you actually run it. What Is An Execution Plan or Explain Plan?Īn Execution Plan (sometimes called an Explain Plan) is a list of steps that the database will take to run your query and give you the results you need.

How To Read The SQL Developer Execution Plan.How To See The SQL Developer Execution Plan.What Is An Execution Plan or Explain Plan?.

Toad sql cost