How would you optimize a slow SQL query?

1 Answers  

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

0 Answers  

---

Explain the different normalization forms?

0 Answers  

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

0 Answers  

---

select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help

6 Answers  

---

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?

5 Answers   Zensar,

---

How to create a new table in your schema?

0 Answers  

---

what are the different types of cursors? explain?

4 Answers  

---

What is private procedure oracle?

0 Answers  

---

Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,

---

What is the difference between 10g OEM and 11g OEM?

0 Answers   MCN Solutions,

---

How to create a stored procedure in oracle?

0 Answers  

---