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 the properties and different types of sub-queries? : Sql dba

0 Answers  

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

0 Answers  

---

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

0 Answers  

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

---

Can unique keys be null?

0 Answers  

---

What is group function in sql?

0 Answers  

---

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

---

Can a table contain multiple foreign key’s?

0 Answers  

---

How do you clear the screen in sql?

0 Answers  

---

Is pl sql a programming language?

0 Answers  

---

How to sort the rows in sql.

0 Answers  

---