Re:SQL Indexing and Tuning e-Book
by Negitivefrags on Sunday December 16, 2012 @05:45PM
(#4929897)
I had seen this before, but I can't recommend it enough.
I very much like resources like this that explain things by explaining how they are implemented. Once you understand the basics of how a database is implemented, a lot of the performance implications of your queries make sense.
It also really helps in the understanding of what is going on in EXPLAIN output.
Re:SQL Indexing and Tuning e-Book
by btilly on Sunday December 16, 2012 @06:47PM
(#4930070)
I agree. I took an Oracle course on this stuff a few years ago. This has proven invaluable for me in understanding performance in a variety of databases since.
I very much like resources like this that explain things by explaining how they are implemented. Once you understand the basics of how a database is implemented, a lot of the performance implications of your queries make sense.
It also really helps in the understanding of what is going on in EXPLAIN output.