List Tables That Contain Special Indexes
By SQLRx Admin | ColumnStore , SQL Administration , SQL Server , Tip of the Month
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 […]
Continue reading