-
Course
- Data
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.
What you'll learn
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.
Table of contents
- Version Check | 20s
- Introduction | 3m 6s
- Solving Slow-running Reports | 3m 3s
- Defining a Columnstore Index | 2m 55s
- How Data Is Stored | 2m 38s
- Evolving Columnstore | 3m 19s
- Exploring Columnstore Benefits | 2m 51s
- Choosing Columnstore | 2m 27s
- Skipping Columnstore | 2m 20s
- Demo: Creating Our Test Environment | 7m 31s
- Demo: Comparing Index Size | 5m 23s
- Summary | 2m 36s
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 Courses by Jared