From the course: Developing Microsoft SQL Server 2016 Databases
Join today to access over 25,500 courses taught by industry experts.
Design spatial and XML indexes - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
Design spatial and XML indexes
- [Narrator] Special consideration needs to be given to creating indexes on spatial and XML columns in a table. Since these two data types don't follow the normal sorting methods that applies to numeric or alphanumeric data, Sequel Server supports indexes specific to their data types. Spatial data consists of points, lines and polygons that represent features located on a 2D plane using geometry data type or on a 3D sphere using the geography data type. Sequel Server can use these locations to determine features that are near one another or contained within a political boundary and so on. Remember that the entire point of an index is to quickly eliminate large numbers of records with searching for a specific records. To do this, spacial indexes divide space up into a grid of areas. Typically a four-cell by four-cell grid or an eight-by-eight grid. These can be used to narrow down a search. Through a process of…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.