Book description
- Properly index row store, columnstore, and in-memory tables
- 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
- Manage the big picture: Encompass all indexes in adatabase, and all database instances on a server
Table of contents
- Cover
- Front Matter
- 1. Index Fundamentals
- 2. Index Storage Fundamentals
- 3. Index Metadata and Statistics
- 4. XML Indexes
- 5. Spatial Indexing
- 6. Indexing Memory-Optimized Tables
- 7. Full-Text Indexing
- 8. Indexing Myths and Best Practices
- 9. Index Maintenance
- 10. Indexing Tools
- 11. Indexing Strategies
- 12. Query Strategies
- 13. Monitoring Indexes
- 14. Index Analysis
- 15. Indexing Methodology
- Back Matter
Product information
- Title: Expert Performance Indexing in SQL Server 2019: Toward Faster Results and Lower Maintenance
- Author(s):
- Release date: November 2019
- Publisher(s): Apress
- ISBN: 9781484254646
You might also like
book
SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under …
book
Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads
Meet the challenge of storing and accessing analytic data in SQL Server in a fast and …
book
SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and …
book
SQL Server Query Tuning and Optimization
Get well-versed with ready-to-use techniques for creating high-performance queries and applications Key Features Speed up queries …