what is explain plan?

Question Posted / lakshminarayana reddy

4 Answers
19935 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is explain plan?..

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

what is explain plan?..

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

what is explain plan?..

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

what is explain plan?..

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

Post New Answer