C H A P T E R 18
Indexing
Effective indexing is fundamental to making database applications find the results you want quickly and efficiently. You’re probably already familiar with SQL Server’s clustered and nonclustered indexes, which index one or more columns of data, such as columns of int, char, or datetime data. However, SQL Server also includes a type of index specifically designed for indexing spatial data, called (unsurprisingly) a spatial index.
A spatial index can be created only on a column of the geography or geometry datatype, and columns of these datatypes can only be added to a spatial index; you cannot include a geography column in a normal nonclustered index, for example.
In this chapter I’ll explain how spatial indexes work, ...
Get Pro Spatial with SQL Server 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
