Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP
- 1 Answers
- 8838 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
Explain how to use transactions efficiently : transact sql
What is the usage of sql functions?
what are all the common sql function? : Sql dba
What is orm in sql?
Is coalesce faster than isnull?
What is a left inner join?
What can you do with pl sql?
how can we repair a mysql table? : Sql dba
What are the main features of cursor?
How many types of triggers exist in pl/sql?
How can check sql version from command line?
Explain ttitle and btitle.
What is sql catalog?
What is natural join in sql?
How do I start sql from command line?
