Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Optimizing Query Performance with Columnstore Indexes

via Pluralsight

Overview

Have you considered creating columnstore indexes to defeat slow
queries? Well, this course is for you! Take your skills to the next level by
learning how columnstore indexes can boost performance in today's busy database environment.

High-performance queries are vital for any SQL developer in today's data- driven world. You may have tried columnstore indexes but left with more questions than answers. In this course, Optimizing Query Performance with Columnstore Indexes, you'll learn core skills for building columnstore indexes in your environment. First, you'll learn what columnstore is and how it differs from rowstore. Understanding the columnstore architecture helps you decide the correct path when it's time to implement. Next, you'll discover the various types of columnstore indexes and which one to create based on your database's workload. Also, you'll learn several features built into columnstore, allowing faster performance. Finally, you'll explore several techniques for getting the most from your new columnstore indexes. When you're finished with this course, you'll have the skills and knowledge necessary to implement and optimize columnstore indexes in your unique environment.

Syllabus

  • Course Overview 1min
  • Introducing Columnstore Indexes 14mins
  • Examining the Structure of Columnstore Indexes 21mins
  • Creating Your First Columnstore Index 30mins
  • Optimizing Columnstore Index Performance 31mins
  • Monitoring and Maintaining Index Health 23mins
  • Building Columnstore Indexes in the Real World 29mins

Taught by

Jared Westover

Reviews

4.7 rating at Pluralsight based on 10 ratings

Start your review of Optimizing Query Performance with Columnstore Indexes

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.