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
Explain correlated query work?
Explian rowid, rownum? What are the psoducolumns we have?
Where is pl sql used?
what is sql server agent? : Sql dba
What does (+) mean in sql joins?
Can we call procedure in select statement?
How many clustered indexes can you have?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is sql injection owasp?
what tools available for managing mysql server? : Sql dba
Can we perform dml in function?
How delete a row in sql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
Which one is faster ienumerable or iqueryable?
What are sql objects?
