| 书目名称 | Expert Performance Indexing in Azure SQL and SQL Server 2022 | | 副标题 | Toward Faster Result | | 编辑 | Edward Pollack,Jason Strate | | 视频video | | | 概述 | Covers new features and conventions in SQL Server 2022.Helps you avoid getting caught by performance-damaging myths.Highlights advanced features such as indexing for memory-optimized tables | | 图书封面 |  | | 描述 | 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 co | | 出版日期 | Book 2023Latest edition | | 关键词 | SQL Server; Covering Index; Columnstore Index; Row Store Index; Dynamic Management Views; Azure SQL Datab | | 版次 | 4 | | doi | https://doi.org/10.1007/978-1-4842-9215-0 | | isbn_softcover | 978-1-4842-9214-3 | | isbn_ebook | 978-1-4842-9215-0 | | copyright | Edward Pollack and Jason Strate 2023 |
The information of publication is updating
|
|
发表于 2025-3-21 18:35:08
