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

What are triggers and its uses?

0 Answers  

---

How to get list of all tables from a database?

0 Answers  

---

what is global variable in pl/sql

1 Answers  

---

Explain ttitle and btitle.

0 Answers  

---

Explain table and field in sql?

0 Answers  

---

I want to know the difference between A Record Type and a Table.

3 Answers   Thermotech,

---

Talk about views

10 Answers   Polaris,

---

define data blocks ? : Sql dba

0 Answers  

---

How is data stored in sql?

0 Answers  

---

what is a trigger in mysql? Define different types of trigger. : Sql dba

0 Answers  

---

i don't want the message as 14 rows updated just it should update what it will do

4 Answers  

---

Can you upgrade sql express to full sql?

0 Answers  

---