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
Can we have two clustered index on a table?
What is crud diagram?
What is not in sql?
what is collation? : Sql dba
How many types of sql are there?
what is view? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
Can we create table inside stored procedure?
What is a crud api?
What view means?
Why is %isopen always false for an implicit cursor?
Write a sql query to convert all character to uppercase after hypen.
Is delete faster than truncate?
Define join and name different types of joins?
What is cursor status?
