Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is Oracle Explain plan?

April 26, 2017explain Oracle Plan

0

Posted

What is Oracle Explain plan?

1 Answer

0

Posted

Whenever you issue an SQL statement to read or write data in Oracle, Oracle internally builds a statement execution plan. An execution plan defines how Oracle executes the query . For example , whether to use index or not, which index to use, how to perform the joins between tables etc etc. Oracle provides EXPLAIN PLAN utility to explore the execution plan before you actually run a SQL statement so that you can make necessary performance tuning changes to the sql statement. Syntax for EXPLAIN PLAN is : : Explain plan for your_sql_statement; When you do explain plan Oracle fills a special table . The table name can be specified using following syntax. : Explain plan INTO you_table_name FORur_sql_tatement; If you do not specify a table name it uses a default table called PLAN_TABLE .