If you have a slow web app and you suspect the database is part of the issue, then this is for you.
I’m not pretending to be a Join-fu Drunken Query Master at this point, but I’ve had success dealing with poorly performing database-driven applications, based on research and tweaking. The slides are a slightly prettified version of notes I originally collected for myself. YMMV.
I’d love to learn about your experiences, and I think the community would also like to see whatever you can share.