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 is a bitmap index?

4 Answers   Choice Solutions, Infosys,

---

What is the command used to fetch the first 5 characters of a string?

0 Answers  

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  

---

how to shut down the server with 'mysqladmin'? : Sql dba

0 Answers  

---

What is crud sql?

0 Answers  

---

---

What is normalization? dec 2009

3 Answers   Cognizant,

---

What are the set operators in sql?

0 Answers  

---

Which type of cursor is used to execute the dml statement?

0 Answers  

---

What is indexing oracle sql?

0 Answers  

---

What is the difference between a primary key and a unique key?

0 Answers  

---

Do prepared statements prevent sql injection?

0 Answers  

---

What is sql integrity?

0 Answers  

---