SOME DO'S AND DONT'S

DO

• 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 this document

DO NOT

• 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