Answer / bipin yadav

Query Optimizer is means how to imrprove the perfomance of
the query,to this we have to extract the explain plan of
that quey usin the set option on the SQL PLUS,using the
commond "SET AUTOTRACE TRACE EXP" we can see the query
cost....:-)

Answer / madhu sekhar

This answer i told. I am using PL/SQL DEVELOPER tool. In
that i go for Explain plan method based on cost of the
query i optimize my Query.

If some others answers is the pls share with me

What are the main diff. between oracle 7.3 and oracle 8i?

1 Answers  

---

How to clone the database using RMAN back

0 Answers  

---

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

0 Answers  

---

Describe the P2P cycle ?

1 Answers  

---

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

0 Answers  

---

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

0 Answers   Accenture,

---

Is it possible to drop a column in a table which contains only one column? How?

1 Answers  

---

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

0 Answers   HCL,

---

What type of index should you use on a fact table?

1 Answers  

---

pl help me, i want oracle HRMS training institute address,in chennai

8 Answers  

---

Describe what redo logs are.

1 Answers  

---

How do you add a data file to a tablespace?

1 Answers  

---