Nonclustered columnstore indexes
After all of the theoretical introduction, it is time to start using the columnar storage. You will start by learning how to create and use nonclustered columnstore indexes (NCCI). You already know from the previous section that a NCCI can be filtered. Now you will learn how to create, use, and ignore a NCCI. In addition, you will measure the compression rate of the columnar storage.
Because of the different burdens on SQL Server when a transactional application uses it compared to analytical applications usage, traditionally, companies split these applications and created data warehouses. Analytical queries are diverted to the data warehouse database. This means that you have a copy of data in your data warehouse, ...
Get SQL Server 2016 Developer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
