Answer / 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.

Answer / sureshkumar.somayajula

Explain Plan determines the execution plan for SQL
Statements.

Syntax:

expalin paln
set statement_id= ' Text '
schemaname.Table_name@Databaselink
for Statement.

Answer / b.v.srinivas

Explian plan describes the effective way to process sql
statement.
Explain plan is generated by Optimizer.
And explain plan is stored in library cache.

Answer / ashok

Explain plan shows the details of the joins cordinality and
time taken.we can easily find the what join is taking much
time in a SQL query. by clicking F5 you can see the explin
plan in PL/SQL developer.

What is sql table?

0 Answers  

---

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,

---

What are the two types of periodical indexes?

0 Answers  

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

0 Answers  

---

What is difference between stored function and application function?

0 Answers  

---

What is a 'instead of trigger'?

3 Answers   Eenadu, TCS,

---

Which is better join or inner query?

0 Answers  

---

What are the features of pl sql?

0 Answers  

---

What is primary key sql?

0 Answers  

---

how can we destroy the cookie? : Sql dba

0 Answers  

---

How many sql core licenses do I need?

0 Answers  

---

what is innodb? : Sql dba

0 Answers  

---