AN INTRODUCTION TO ORACLE SQL STATEMENT TUNING
21st Feb 2003
SOME DO'S AND DONT'S
- DO use bind variables wherever possible (including in cursors)
- DO check your statements before releasing them, even if you don't want to tune your
statements as you develop them.
- DO take any advice you can from the DBA's. Most are experts in their field and want to help
- DO co-operate with other developers regarding inefficient queries, or tables designs.
50 other developers might also be fed up of performance on a certain table. If you are
all having the same difficulty it might be time to get together and consider options
- DO consider this document as only a starting point, it is very abstract in places
- DO let me know of any other things you think should be added,corrected or clarified in
Back to Contents
- DO NOT assume performance to be someone elses problem. It is everyones problem
- DO NOT listen to a word the DBA's say. They're all evil
- DO NOT assume that what works well today will work well tomorrow.
- DO NOT believe everything you are told, there are many, many myths out there,
take a quick look in the Oracle Docs when you get a chance