An explain plan is a visual representation of the execution plan that Oracle will use to execute a SQL statement. It shows the steps that Oracle will take to execute the statement, as well as the estimated cost of each step. This information can be used to identify performance bottlenecks and to improve the performance of SQL statements.
There are two ways to check explain plan in Toad: using the GUI or using the command line.
