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 are all the different normalization?
What is a sql statement?
What is sql and also describe types of sql statements?
can we update a view which is created from two tables
what is collation? : Sql dba
what are the join types in tsql? : Transact sql
Why triggers are used?
How many triggers can be applied to a table?
Why is sharding used?
What is the difference between the Primary and Foreign key?
how to get a list of columns in an existing table? : Sql dba
Does group by remove duplicates?