Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is sql rowcount?
what is union? : Sql dba
What do you understand by pl/sql packages?
Explain the uses of control file.
Explain constraints in sql?
Can we use joins in subquery?
What is scalar function in sql?
Is sql the best database?
Is sql considered coding?
what are wild cards used in database for pattern matching ? : Sql dba
How many subqueries can be nested in a statement?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
What is linq to sql?
What is database white box testing and black box testing?
Why truncate is used in sql?
