Abstract
Indexes assist with query processing by speeding up access to the data stored in tables and views. Indexes allow for ordered access to data based on an ordering of data rows. These rows are ordered based upon the values stored in certain columns. These columns comprise the index key columns, and their values (for any given row) are a row’s index key.
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
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2012 Jason Brimhall
About this chapter
Cite this chapter
Brimhall, J., Dye, D., Gennick, J., Roberts, A., Sheffield, W. (2012). Managing Indexes. In: SQL Server 2012 T-SQL Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4201-7_16
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4201-7_16
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4200-0
Online ISBN: 978-1-4302-4201-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books