SQL Query Tuning: The Legend of Drunken Query Master
Jay Pipes (15.Sep.2008 at 13:30)
Talk at Zend/PHP Conference & Expo 2008 (English - US)
Once upon a time, a young application developer embarked on a journey to master the art of database application tuning. Her path led to studying at the feet of the Drunken Query Master. After years studying the arts of join-fu, explain-jitsu and table-kee-do, she returned to her home. Jay Pipes has catalogued the lessons she learned from the Drunken Query Master and shares her knowledge with tutorial goers.
Axioms that Jay will expound upon:
* Thou shalt not fight with the Database for it is thy Friend
* The Art of Join-Fu is thy best defense against the Evil Enemy Army of Correlated Subqueries
* The Art of Join-Fu shall protect thee against Many-To-Many Relationships
* The Art of Join-Fu shall deliver thee from the Adjacency List Model
* Table-kee-do shall show thee the Path of (De)Normalization
* Thou shall understand the Art of Table-kee-do in order to Avoid the Fury of the Query Cache
* Without the strength of Explain-jitsu, thou shall perish in the Forest of Misunderstanding
* Thou shall befriend the Index, for it is a Master of Join-fu and will protect thee from the Ravages of the Table Scan
Quicklink: https://joind.in/372
By clicking this button you are declaring that you are the speaker responsible for it and a claim request will be sent to the administrator of the event.
If the claim is approved you will be able to edit the information for this talk.
Are you sure?
16.May.2009 at 20:14 by Keith Casey
This is an excellent talk but major portions of it were over my head. I've seen it once and read the slides a half-dozen times and get something new (and often useful) each time.