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 are date and time data types? : Sql dba
How can you view the errors encountered in a trigger?
What is the maximum rows in csv?
Does a join table need a primary key?
What is rtm stands for?
Can a foreign key be null?
Explain the commit statement.
Can a table contain multiple foreign key’s?
what is “go” in t-sql? : Transact sql
What is foreign key in sql with example?
how can we destroy the cookie? : Sql dba
What is using in sql?
What is the use of non clustered index?
What is the importance of sqlcode and sqlerrm?
What is transaction control language (tcl)?
