Answer / chiranjeevi

After generating explan plan the out put of the query
stored in plan_table.from this table if you finding any
table access (full) in output,the query having perfomence
problem.

according you can create the index or primary key or unique
in proper table.

Answer / azuan

example

explain analyze select br_loc,count(insp_id) from insp where
date_create between '2010-07-01 00:00:00' and '2010-07-31
23:59:59' group by br_loc

Can we use distinct and group by together?

0 Answers  

---

How many times can we commit in a loop?

0 Answers  

---

What are the advantages of sql? Explain

0 Answers  

---

what are the advantages of cursors than procedures?

2 Answers  

---

display null value rows with out using null function?

8 Answers   Infosys,

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

0 Answers  

---

What is difference between table and view?

0 Answers  

---

Can i possible to see Table Details ? Ex : Table Name Date Time User Emp May/18/2010 12:59pm Scott

3 Answers  

---

how to rename an existing column in a table? : Sql dba

0 Answers  

---

What types of commands can be executed in sql*plus?

0 Answers  

---

What is primary key in db?

0 Answers  

---

how can create data base link for tow servers (scott schema) give examples plz

2 Answers  

---