HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP
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
What is the difference between numeric and autonumber?
What is a column in a table?
What is the use of index in hive?
How to pronounce postgresql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
How does join work in sql?
What is the basic structure of an sql?
What language is oracle sql developer?
Is primary key a clustered index?
Can we use delete in merge statement?
What is sql query limit?
What are the uses of sysdate and user keywords?
Can we use rowid as primary key?
What is the maximum number of columns in sql table?
Is left join faster than join?