what is explain plan?
Answers were Sorted based on User's Feedback
The explain plan command is a tool to tune SQL statements.To
use if you must have an explain_table generated in the user
you are running the explain plan for.This is created by
using the utlxplan.sql script.once the explain plan table
exists u run the explain plan command giving as it's
argument the SQL statement to be explained.The explain_plan
table is then queried to see the execution plan of the
statement.Explain plan can also be run using tkprof.
Is This Answer Correct ? | 11 Yes | 1 No |
Answer / sureshkumar.somayajula
Explain Plan determines the execution plan for SQL
Statements.
Syntax:
expalin paln
set statement_id= ' Text '
schemaname.Table_name@Databaselink
for Statement.
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / b.v.srinivas
Explian plan describes the effective way to process sql
statement.
Explain plan is generated by Optimizer.
And explain plan is stored in library cache.
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / ashok
Explain plan shows the details of the joins cordinality and
time taken.we can easily find the what join is taking much
time in a SQL query. by clicking F5 you can see the explin
plan in PL/SQL developer.
Is This Answer Correct ? | 11 Yes | 7 No |
What do you mean by table in sql?
Is natural join and inner join same?
How to execute OS(operating system) command from pl/sql?
What is pragma in pl sql?
What is the command used to fetch first 5 characters of the string?
Explain the usage of WHERE CURRENT OF clause in cursors ?
What is sql server and ase?
What is the difference between nested table and varray?
How do you retrieve the last N records from a table?
what is indexing, searching and user interface?
What is the process of debugging?
Why do we use partitions in sql?