From the course: Implementing a Data Warehouse SQL Server 2019
Join today to access over 24,000 courses taught by industry experts.
Rebuild columnstore indexes - SQL Server Tutorial
From the course: Implementing a Data Warehouse SQL Server 2019
Rebuild columnstore indexes
- Over time, the indexes in your data warehouse can become fragmented, which will negatively impact query performance. You can keep an eye on index fragmentation by looking at the properties here in Management Studio. Now, our KinetEco data warehouse doesn't yet have any data. So, let's take a look inside of the Wide World Importers database instead. I'll expand that open and expand the tables folder. I'm going to find the table for Fact.Order and expand that open and take a look inside of the indexes folder. Now, there are a number of different indexes in this table that we could take a look at. I'm going to right click on the first one, the clustered column store index, and then choose properties from the pop up menu. Then I'm going to switch over to the fragmentation page. This is one place where you can take a look at the index fragmentation percentages. This index isn't fragmented at all, but as data gets written to…
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.