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 procedures used for?

0 Answers  

---

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

4 Answers  

---

how to create a new table in mysql? : Sql dba

0 Answers  

---

Which join is default?

0 Answers  

---

select 10 from dual; y its showing all the rows with 10?

1 Answers  

---

What is function and procedure in pl sql?

0 Answers  

---

What does fetching a cursor do?

0 Answers  

---

Difference between aggregate function and analytical function?

3 Answers   Metric Stream,

---

how to get help information from the server? : Sql dba

0 Answers  

---

What are the PL/SQL Statements used in cursor processing ?

4 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---

How to rename a column in the output of sql query?

0 Answers  

---