Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is explain plan?

Answers were Sorted based on User's Feedback



what is explain plan?..

Answer / veereshkethari

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

More SQL PLSQL Interview Questions

What is the difference between RDBMS and DBMS?

20 Answers   Practical Viva Questions, Sapient, Stag Computers,


what are the limitations of identity column? : Transact sql

0 Answers  


What is Overloading of procedures ?

2 Answers  


Is pl sql different from sql?

0 Answers  


Can we call procedure in select statement?

0 Answers  






Explain Connect by Prior?

2 Answers  


Define union, minus, union all, intersect ?

0 Answers  


What is pl sql script?

0 Answers  


Is mariadb a nosql database?

0 Answers  


While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,


What is the syntax and use of the coalesce function?

0 Answers  


What is a left join?

0 Answers  


Categories