Optimizing Query Performance with Columnstore Indexes

Have you considered implementing columnstore indexes to speed up your queries? Well, this course is for you! Take your skills to the next level by learning how columnstore indexes can boost performance in an operational database environment today.
Course info
Rating
(10)
Level
Intermediate
Updated
Apr 17, 2020
Duration
2h 53m
Table of contents
Description
Course info
Rating
(10)
Level
Intermediate
Updated
Apr 17, 2020
Duration
2h 53m
Description

High-performing queries are a requirement for any SQL developer in today's data-driven world. Maybe you experimented with columnstore indexes in the past but were left with more questions than answers. In this course, Optimizing Query Performance with Columnstore Indexes, you will gain foundational knowledge for building columnstore indexes in your environment. First, you will learn what columnstore is and how it differs from rowstore, giving you an understanding of the columnstore architecture that will assist you in making an informed decision on when to implement it. Next, you will discover the various types of columnstore indexes and which one to create based on your environment’s workload, as well as several features built into columnstore enabling faster performance. Finally, you will explore several techniques for getting the most from your new columnstore indexes. When you are finished with this course, you will have the skills and knowledge necessary to implement and optimize columnstore indexes in your unique environment.

About the author
About the author

Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. Data and technology have been paramount to his career for over 13 years. These days he focuses on SQL Server and finding ways to tell inspiring stories with raw data.

More from the author
Implementing SSRS Report Layouts
Beginner
2h 15m
Aug 28, 2020
More courses by Jared Westover
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi, everyone. My name is Jared West over and welcome to my course. Optimizing query performance with column store indexes. I'm a sequel architect in a Microsoft Certified Solutions expert in data management and analytics. Most importantly, I love working with data. If your data environment is constantly growing in size, you'll likely run into unexpected performance issues when running queries. These same queries could have been blazing fast just a few months or even weeks ago. No one wants to get e mails from angry customers suffering because reports air taking an excessive amount of time to generate this course is an introduction and exploration in tow. How COLUMN. Story indexes may help your queries performance Having knowledge of sequel, server and prior experience with writing queries will be helpful as you go through this course. Some of the major topics that will cover include how columns or indexes differ from Rose Store. What exactly makes a column store index lightning fast, choosing between a clustered and non clustered index, determining if column store will work for you. By the end of this course, you will have a solid foundation to start creating and optimizing column store indexes. I hope you'll join me on this journey. To learn column store indexes with optimizing query performance. With column store indexes course at Pluralsight.