News for hackers. Stuff that matters.
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.