Due to the increasing complexity in application workloads and query engines, database administrators are turning to automated tuning tools that systematically explore the space of physical design alternatives. A critical element of such tuning is physical database design since the choice of physical structures has a significant impact on the perfor
The book starts with a good comparison of imperative vs declarative search in C# vs SQL and provides rationale for query optimizer. Overall, practical parts of the book - for Database tuning advisor, etc. are good. But the theoretical part is too abstract. In reality tuning it's about what-if analysis, not an optimization based on linear programming, etc.