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.

How to pronounce postgresql?

0 Answers  

---

How to convert comma separated string to array in pl/sql?

0 Answers  

---

What is an inner join sql?

0 Answers  

---

What is sql engine in oracle?

0 Answers  

---

What is oracle sql developer?

0 Answers  

---

Difference between truncate, delete and drop commands?

0 Answers  

---

What are all the different types of indexes?

0 Answers  

---

What steps server process has to take to execute an update statement?

0 Answers  

---

what is outer join? what is selef join? what is difference between them? what is cartecion join?

1 Answers   Fiserv, Herbinger, Synechron,

---

Are sql database names case sensitive?

0 Answers  

---

i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#

1 Answers  

---

What are sql ddl commands?

0 Answers  

---