Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP
- 1 Answers
- 8742 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Define sql delete statement.
What is the purpose of a sql?
Which data dictionary views have the information on the triggers that are available in the database?
Which kind of parameters cannot have a default value in pl sql?
What is a full join?
what is top in tsql? : Transact sql
What is bind reference and how can it be created?
What are reports usually used for?
Can we insert in view in sql?
What are keys in sql?
What are different types of indexes?
What is $$ in sql?
Which type of cursor is used to execute the dml statement?
What is coalesce sql?
what is union, minus and interact commands? : Sql dba
