Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud

Take a deep dive into perhaps the single most important facet of query performance--indexes--and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query Store, deeper content around Intelligent Query Processing, and other updates to help you optimize query execution and make performance improvements to even the most challenging workloads.
The book begins with explanations of the types of indexes and how they are stored in a database. Moving further into the book, you will learn how statistics are critical for optimal index usage and how the Index Advisor can assist in reviewing and optimizing index health. This book helps you build a clear understanding of how indexes work, how to implement and use them, and the many options available to tame even the most large and complex workloads.

What You Will Learn

• Properly index row store, columnstore, and memory-optimized tables
• Make use of Intelligent Query Processing for faster query results
• Review statistics to understand indexing choices made by the optimizer
• Apply indexing strategies such as covering indexes, included columns, and index intersections
• Recognize and remove unnecessary indexes
• Design effective indexes for full-text, spatial, and XML data types

Who This Book Is For
Azure SQL and SQL Server administrators and developers who are ready to improve the performance of their database environment by thoughtfully building indexes to speed up queries that matter the most and make a difference to the business

深入探索可能是查詢性能中最重要的方面之一 - 索引 - 以及如何最佳使用它們。本書第四版已更新至 SQL Server 2022 和 Azure SQL，包括與列存儲索引相關的新指導和功能，改進並整合了有關查詢存儲的內容，更深入地介紹了智能查詢處理的內容，以及其他更新，以幫助您優化查詢執行並改進性能，即使是最具挑戰性的工作負載也能如此。

本書首先解釋了索引的類型以及它們在數據庫中的存儲方式。隨著書籍的深入，您將學習統計數據對於最佳索引使用的重要性，以及索引顧問如何幫助您審查和優化索引健康狀況。本書幫助您建立對索引工作原理的清晰理解，以及如何實施和使用它們，以及應對最大和最複雜工作負載的眾多選項。

您將學到以下內容：
- 正確為行存儲、列存儲和內存優化表建立索引
- 利用智能查詢處理加快查詢結果
- 審查統計數據以了解優化器所做的索引選擇
- 應用索引策略，如覆蓋索引、包含列和索引交集
- 辨識並刪除不必要的索引
- 為全文、空間和 XML 數據類型設計有效的索引

本書適合 Azure SQL 和 SQL Server 管理員和開發人員，他們希望通過深思熟慮地建立索引來加快最重要的查詢速度，並對業務產生影響，從而改善其數據庫環境的性能。

Edward Pollack has over 20 years of experience in database and systems administration, architecture, and development, becoming an advocate for designing efficient data structures that can withstand the test of time. He has spoken at many events, such as SQL Saturdays, PASS Data Community Summit, Dativerse, and at many user groups and is the organizer of SQL Saturday Albany. Ed has authored many articles, as well as the following Apress books: Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads; and a chapter in Expert T-SQL Window Functions in SQL Server. His first patent was issued in 2021, focused on the compression of geographical data for use by analytic systems.
In his free time, Ed enjoys video games, sci-fi and fantasy, traveling, and baking. He lives in the sometimes-frozen icescape of Albany, NY, with his wife Theresa and sons Nolan and Oliver, and a mountain of (his) video game plushies that help break the fall when tripping on (their) toys.

Jason Strate is a database architect and administrator with more than 15 years of experience. He has been a recipient of Microsoft's Most Valuable Professional designation for SQL Server since July 2009. His experience includes design and implementation of both OLTP and OLAP solutions, as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. He is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008.
Jason is actively involved with his local PASS chapter (SQL Server User Group) and serves as its director of program development. He worked with the board to organize the PASSMN SQL Summit 2009 for the local community. He enjoys helping others in the SQL Server community and does this by presenting at technical conferences and user group meetings. Most recently, he has presented at the SSWUG Virtual Conferences, TechFuse, numerous SQL Saturdays, and at PASSMN user group meetings.
Jason is a contributing author for the Microsoft whitepaper on "Empowering Enterprise Solutions with SQL Server 2008 Enterprise Edition." He is an active blogger with a focus on SQL Server and related technologies.

Edward Pollack擁有超過20年的資料庫和系統管理、架構和開發經驗，成為一位倡導設計高效資料結構的倡導者，能夠經受住時間的考驗。他曾在許多活動中演講，如SQL Saturdays、PASS Data Community Summit、Dativerse，以及許多使用者群組，並且是SQL Saturday Albany的組織者。Ed撰寫了許多文章，以及以下Apress書籍:《Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server》、《Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads》和《Expert T-SQL Window Functions in SQL Server》中的一章。他的第一項專利於2021年發布，專注於地理數據的壓縮，以供分析系統使用。在空閒時間，Ed喜歡玩視頻遊戲、科幻和奇幻、旅行和烘焙。他與妻子Theresa和兒子Nolan和Oliver一起居住在紐約州奧爾巴尼的有時結冰的冰原上，還有一堆（他的）視頻遊戲玩偶，可以在（他們的）玩具上絆倒時減輕摔倒的力道。

Jason Strate是一位擁有超過15年經驗的資料庫架構師和管理員。自2009年7月以來，他一直是Microsoft SQL Server最有價值專家(Most Valuable Professional)的獲獎者。他的經驗包括設計和實施OLTP和OLAP解決方案，以及評估和實施SQL Server環境的最佳實踐、性能和高可用性解決方案。他是一位SQL Server MCITP，並參與了SQL Server 2008的Microsoft認證考試的開發。

Jason積極參與當地的PASS章節(SQL Server使用者群組)，並擔任其節目開發總監。他與該組織合作，為當地社區組織了PASSMN SQL Summit 2009。他喜歡幫助SQL Server社區的其他人，通過在技術會議和使用者群組會議上發表演講來實現這一目標。最近，他在SSWUG虛擬會議、TechFuse、許多SQL Saturdays和PASSMN使用者群組會議上發表演講。

Jason是Microsoft白皮書《Empowering Enterprise Solutions with SQL Server 2008 Enterprise Edition》的撰稿人之一。他是一位活躍的博客作者，專注於SQL Server和相關技術。