Connor McDonald writes that It’s just bad code or bad design … most of the time for Oracle performance problems.
I have spent the past year doing performance modelling of a new product that is being rolled progressively to clients. The most frustrating thing has the lack of meaningful feedback from the product support group. Everytime I raise a concern that the performance is not as expected, I get the platitude that the product is performing as expected.
I have recently used SQLTXPLAIN to solve a production performance issue. This post is about my experiences with this tool.