Abstract
Effective indexing is the key to making database applications find the results you want quickly and efficiently. In addition to the geometry and geography datatypes designed to store spatial data, SQL Server 2008 also includes a new type of index for use with spatial data, called (perhaps unsurprisingly) a spatial index. In this chapter I’ll explain how spatial indexes work, and how you can use a spatial index to improve the speed of your spatial queries.
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
© 2009 Alastair Aitchison
About this chapter
Cite this chapter
(2009). Indexing. In: Beginning Spatial with SQL Server 2008. Apress. https://doi.org/10.1007/978-1-4302-1830-2_14
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1830-2_14
Publisher Name: Apress
Print ISBN: 978-1-4302-1829-6
Online ISBN: 978-1-4302-1830-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books