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.

explain mysql aggregate functions. : Sql dba

939

---

What is dynamic query?

909

---

Are pl sql variables case sensitive?

996

---

Why use subqueries instead of joins?

1028

---

how to shutdown mysql server? : Sql dba

1027

---

what are the type of locks ? : Sql dba

896

---

How do you run a query?

953

---

What is pl sql package?

990

---

What are the advantages of indexing?

926

---

how to convert dates to character strings? : Sql dba

1069

---

What is transaction control language (tcl)?

1069

---

How to run sql statements with oracle sql developer?

998

---

If a cursor is open, how can we find in a pl/sql block?

1103

---

What is a sql*loader control file?

1158

---

What is oracle sql called?

859

---