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 you join views in sql?
Why should I use postgresql?
Are dml statements autocommit?
Is sql workbench free?
Name the operator which is used in the query for pattern matching?
What is the command used to fetch first 5 characters of the string?
what are the advantages of mysql in comparison to oracle? : Sql dba
How many sql statements are used? Define them.
Name some usages of database trigger?
what is a trigger in mysql? Define different types of trigger. : Sql dba
How to load data with sql*loader?
What is the command used to fetch the first 5 characters of a string?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What is pl sql code?
What is the difference between a primary key and a clustered index?
