Answer / daid kumar

The EXPLAIN PLAN statement displays execution plans chosen
by the Oracle optimizer for SELECT, UPDATE, INSERT, and
DELETE statements.
Run This Script To create Plan Table
$ORACLE_HOME/rdbms/admin/UTLXPLAN.SQL
Then Write like this
SQL> EXPLAIN PLAN FOR
SELECT name FROM emp;

Now to see O/P u can select * from "plan_table"

Answer / bharath

explain plan for select * from t1 where num_col = '1';
select * from table(dbms_xplan.display);

Why would you use sql agent? : sql server DBA

0 Answers  

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  

---

how can you find out if a table can be redefined?

0 Answers   Oracle,

---

Give the reasoning behind using an index.

2 Answers  

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

---

what are the differences of where and if in SAS?

0 Answers  

---

wat is global index and local indes

1 Answers   Oracle,

---

Datapump backup steps?

1 Answers  

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

---

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---