What are the steps you will take to improve performance of
a poor performing query?
- 1 Answers
- 2937 Views
- I also Faced
- E-Mail Answers
Answer Posted / Binu Kumar Gautam
Steps to improve query performance include: 1) Reviewing query plan and indexes, 2) Optimizing queries by rewriting them or adding appropriate indexes, 3) Reducing the amount of data fetched, 4) Using stored procedures instead of ad-hoc queries, 5) Considering partitioning large tables, and 6) Monitoring database and server performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
