Good resources for learning database optimization part [closed]

Question

I am good at database(sql) programming part but I want to move ahead into database optimization part like: where and when to indexes, how to decide which query is better than other, how to optimize database. Can you guide me some good resources or books which can lead me to this?

Answer 1

Inside Microsoft SQL Server 2005: Query Tuning and Optimization,

Inside Microsoft SQL Server 2005: T-SQL Querying

Inside Microsoft SQL Server 2005: The Storage Engine

have very deep and thorough explanation of optimizing sql server querying.

Answer 2

SQL Server Query Performance Tuning Distilled, Second Edition