Answer / s.panda

Step1: At first we need to identified the high load SQLs or
top SQLs that are responsible for performance problem or in
another word the sql that consume application workload and
system resources. We can easily identify them by reviewing
past SQL execution history available in the system.

Step 2: Now generate execution plan of those high load sql
statements and verify that the execution plans produced by
the query optimizer for these statements perform reasonably.

Step 3: Implement corrective actions to generate better
execution plans for poorly performing SQL statements. While
taking corrective actions there is many considerations.

What are the types of join and explain each?

0 Answers  

---

How do I count rows in sql?

0 Answers  

---

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 Answers   Fidelity, IBM,

---

Describe different types of general function used in sql?

0 Answers  

---

What is a 'instead of trigger'?

3 Answers   Eenadu, TCS,

---

---

What is pls integer?

0 Answers  

---

What are views in sql?

0 Answers  

---

Define select, insert, create, delete, update, drop keywords

0 Answers  

---

What is indexes?

0 Answers  

---

Can procedure in package be overloaded?

0 Answers   EXL,

---

What are the most important ddl statements in sql?

0 Answers  

---

what is difference between "Primary key" and "Unique key"?

4 Answers   PreVator,

---