Fritchey, Grant

SQL Server Execution Plans: - Third Edition

(No reviews yet) Write a Review
ISBN 13:
9781910035245
author:
Fritchey, Grant
format:
Paperback
publisher:
Red Gate Books
language:
English
Publication Year:
2018
Pages:
520
Dimensions:
23.5 x 19.1 x 2.7 centimetres (0
Genre:
Computers, Server & Database, General Database,
Condition:
New
Availability:
Item usually sent within 5 working days
£19.50

Description

Understanding SQL Server Execution Plans is crucial for optimizing query performance. By examining the execution plan, you can identify the steps SQL Server took to retrieve data, including the data sets involved, table and index usage, join types, filtering, sorting, and aggregation. This knowledge will help you pinpoint the likely source of performance issues.

This book provides a comprehensive guide to reading and interpreting SQL Server Execution plans, covering topics such as capturing plans, common objects in plans, controlling plans with hints and guides, and the Query Store. With this understanding, you'll be better equipped to troubleshoot and resolve performance problems.

While this book will provide you with a solid foundation in reading execution plans, it's essential to remember that you still need to work out the best solution to fix performance issues. However, with this knowledge, you'll have a much better chance of success.

View AllClose

Related Products

Related Products