Hi!
This week I am on a IBM course learning about Information Analysis and Data Quality. So probably I won’t manage to post new questions. Also URS is busy. But I’d anyway like to tell you about my most favourite book about SQL tuning:
SQL Tuning by Dan Tow (O’Reilly Media)
This book opened my mind… It has served me well for many years now, and it still does! Dan describes the contributing factors of SQL performance, ways to influence the optimizer and he describes his own way to represent queries as graphs. I’ve worked on many different RDBMSs and Dan’s conclusions hold true on all of those.