April 10, 2007
Meeting at 19:30 - location: location: namics Zürich @ Konradstrasse 12. Verrrrry close to the main station and tram stop Shilquai #4 and #12.
"Finding Order in Execution" by Lukas Smith
That 5 table join is taking 30 seconds and you do not know why? EXPLAIN is the tool of choice to getting to the bottom if your performance issues. As part of this talk we will go through the necessary jargon, algorithms and tricks to optimize SQL queries. Particular focus will be put on finding the optimal execution plan order and how to get the database to follow this optimal order. The information provided will be useful to users of any database, but MySQL and PostgreSQL will be used as examples.