Spatial datatypes and index

• Spatial index can be based on only a single column of spatial data type
• The table must have a primary key before you can create a spatial index
• Geography and geometry are spatial data types
• STDistance function is a geography function that returns the shortest distance between a point in a geography instance and a point in another geography instance – benefits from a spatial index