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 the different tables present in mysql? : Sql dba
Can a varchar be a primary key?
What are the types of records?
What is a sql instance vs database?
Write a sql select query that only returns each name only once from a table?
Can we create a trigger on view?
What is the use of partition by in sql?
what is the difference between nested subquery and correlated subquery?
How can check sql version from command line?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
When do we use triggers?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
what is schema? : Sql dba
Is sqlexception checked or unchecked?
Which nosql database is best?
