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 difference between inner join and cross join?
Explain the steps needed to create the scheduled job?
How to rename a column in the output of sql query?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
Why functions are used in sql?
How many functions are there in sql?
what is transaction? : Sql dba
How do you copy a table in sql?
Is postgresql a server?
how many columns can be used for creating index? : Sql dba
what is a unique key ? : Sql dba
Is sql developer case sensitive?
What do you understand by pl/sql cursors?
What is consistency?
what is msql? : Sql dba