What do you think?
Rate this book
Automated Physical Database Design and Tuning
Relational database systems have significantly evolved since their inception over 30 years ago. New applications are now more complex than ever and tuning a production system for performance has become a critical yet time-consuming activity. This book shows how to use automated systems for time-efficient database tuning. The author presents a detailed overview of the fundamental research that makes it possible to automatically recommend changes to the physical design of database systems. The book provides a comprehensive overview of the automated tuning tools that can be used to systematically explore the space of alternatives and to guide database administrators.
254 pages, Hardcover
First published February 7, 2011
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
January 30, 2020
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.
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.
Displaying 1 of 1 review