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 is attribute indicator in pl sql?
what is definer rights invoke rights?
suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?
wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure
Which language is used in sql?
What is a database trigger ? Name some usages of database trigger ?
What is sql profiling in oracle?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
Advantages and disadvantages of stored procedure?
what is data control language? : Sql dba
what is sql optimization
What sql database should I use?