Expert performance indexing for SQL Server 2012
Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, Calif. :
Apress
2012.
|
| Edición: | 1st ed. 2012. |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628634106719 |
Tabla de Contenidos:
- Title Page; Copyright Page; Contents at a Glance; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; chapter1: Index Fundamentals; Why Build Indexes?; Major Index Types; Heap Tables; Clustered Indexes; Nonclustered Indexes; Column Store Indexes; Other Index Types; XML Indexes; Spatial Indexes; Full-Text Search; Index Variations; Primary Key; Unique Index; Included Columns; Partitioned Indexes; Filtered Indexes; Compression and Indexing; Index Data Definition Language; Creating an Index; Altering an Index; Dropping an Index; Index Meta Data
- sys.indexessys.index_columns; sys.xml_indexes; sys.spatial_indexes; sys.column_store_dictionaries; sys.column_store_segments; Summary; chapter2: Index Storage Fundamentals; Storage Basics; Pages; Extents; Page Types; File Header Page; Boot Page; Page Free Space Page; Global Allocation Map Page; Shared Global Allocation Map Page; Differential Changed Map Page; Bulk Changed Map Page; Index Allocation Map Page; Data Page; Index Page; Large Object Page; Organizing Pages; Heap Structure; B-Tree Structure; Column Store Structure; Examining Pages; DBCC EXTENTINFO; DBCC IND; DBCC PAGE
- Page Header Only Print OptionHex Rows Print Option; Hex Data Print Option; Row Data Print Option; Page Fragmentation; Forwarded Records; Page Splits; Index Characteristics; Heap; Clustered Index; Non-Clustered Index; Column Store Index; Summary; chapter3: Index Statistics; Index-Level Statistics; DBCC SHOW_STATISTICS; Stats Header; Histogram; Density Vector; Catalog Views; sys.stats; sys.stat_columns; STATS_DATE; Statistics DDL; Index-Level Statistics Summary; Usage Statistics; Header Columns; User Columns; System Columns; Index Usage Stats Summary; Operational Statistics; Header Columns
- DML ActivitySELECT Activity; Range Scan; Singleton Lookup; Forwarded Fetch; Locking Contention; Row Lock; Page Lock; Lock Escalation; Latch Contention; Page I/O Latch; Page Latch; Page Allocation Cycle; Compression; LOB Access; Index Operational Stats Summary; Physical Statistics; Header Columns; Row Statistics; Fragmentation Statistics; Index Physical Stats Summary; Summary; chapter 4:XML, Spatial, and Full-Text Indexing; XML Indexing; Benefits; Categories; Creating an XML Index; Effects on Execution Plans; Effects from a Primary Index; Effects from a Secondary Index; Spatial Data Indexing
- How Spatial Data Is IndexedCreating Spatial Indexes; Supporting Methods with Indexes; Understanding Statistics, Properties, and Information; The Views; The Procedures; Restrictions on Spatial Indexes; Full-Text Indexing; Creating a Full-Text Example; Creating a Full-Text Catalog; Creating a Full-Text Index; Syntax; Key Indexes; Population; StopLists; Full-Text Search Index Catalog Views and Properties; Summary; chapter5: Index Myths and Best Practices; Index Myths; Myth 1: Databases Don't Need Indexes; Myth 2: Primary Keys Are Always Clustered; Myth 3: Online Index Operations Don't Block
- Myth 4: Any Column Can Be Filtered In Multicolumn Indexes
