List Tables That Contain Special Indexes — SQLRx – The Daily Dose


Find out if any of your tables contain special columnstore or spatial indexes. Columnstore indexes organizes the data in columns instead of rows like traditional indexes and can increase performance on large data sets as found in data warehouses. Spatial indexes are a special type of index on a spatial column such as geometry or […]

via List Tables That Contain Special Indexes — SQLRx – The Daily Dose

Advertisements