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 rowtype?

0 Answers  

---

How to call the function and Procedure in trigger?

3 Answers   IBM,

---

How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,

---

what is ref cursor in pl/sql?

3 Answers  

---

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00

3 Answers  

---

---

Can we use ddl statements in stored procedure sql server?

0 Answers  

---

What is the purpose of the partition table?

0 Answers  

---

what is subquery? : Sql dba

0 Answers  

---

Why left join is used in sql?

0 Answers  

---

What is nvarchar in sql?

0 Answers  

---

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,

---

What does select top 1 do in sql?

0 Answers  

---