Abstract
The end goal of this book is to help you improve the performance of your databases through the use of indexes. Before we can move toward that end, we must first understand what indexes are and why we need them. We need look at how nonclustered and column store indexes are laid out and how they rely on other indexes. This chapter will provide the building blocks to understanding the logical design of indexes.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Jason Strate and Ted Krueger
About this chapter
Cite this chapter
Strate, J., Krueger, T. (2012). Index Fundamentals. In: Expert Performance Indexing for SQL Server 2012. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3742-6_1
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3742-6_1
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3741-9
Online ISBN: 978-1-4302-3742-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books