Optimizing Query Performance with Columnstore Indexes
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.
What you'll learn
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.
Table of contents
- Introduction 2m
- Types of Columnstore Indexes 2m
- Which Index to Choose 3m
- Which Index Should You Choose 2m
- Exploring Columnstore Storage 4m
- Reviewing Syntax 2m
- Considerations Before Creating 2m
- Demo: Creating a Columnstore Index 5m
- Demo: Segment Elimination 4m
- Demo: SQL Server 2022 Ordered Columnstore Index 2m
- Summary 3m
About the author
Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. When he started his education, he didn’t consider any other field than computers. Jared has been working with technology for over 15 years. He focuses on SQL Server and finding ways to tell inspiring stories with raw data. Technology became his first love while working on a Tandy back in the ’80s. Undertaking an epic quest, Jared wanted nothing more than to design video games using C. Working with data giv... more