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 is the use of a view in sql?

0 Answers  

---

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

1 Answers   Sierra Atlantica,

---

How delete all records from table in sql?

0 Answers  

---

What is self-join and what is the requirement of self-join?

0 Answers  

---

What are pl/sql cursor exceptions?

0 Answers  

---

What is example of database?

0 Answers  

---

Can we use joins in subquery?

0 Answers  

---

What is identity column in sql server?

0 Answers  

---

Why cross join is used?

0 Answers  

---

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

What are instead of triggers?

0 Answers  

---

I need a function for a train ticket reservation please answer it thanks in advance

0 Answers  

---