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.

1. Course Overview

1. Course Overview

2. Introducing Columnstore Indexes

1. Introduction

2. Why Is Columnstore Needed

3. What Is a Columnstore Index

4. Demo - Creating Your Demo Environment

5. Course Structure

3. Examining the Structure of Columnstore Indexes

1. Introduction

2. Two Storage Methods

3. How Is Data Physically Stored

4. History of Columnstore Indexes

5. Benefits of Columnstore Indexes

6. When You Should Pick or Skip Columnstore

7. Demo - Comparing Index Size

8. Summary

04. Creating Your First Columnstore Index

01. Introduction

02. Types of Columnstore Indexes

03. Which Index to Choose

04. Which Index Should You Choose

05. Exploring Columnstore Storage

06. Reviewing Syntax

07. Considerations Before Creating

08. Demo - Creating a Columnstore Index

09. Demo - Segment Elimination

10. Demo - SQL Server 2022 Ordered Columnstore Index

11. Summary

05. Optimizing Columnstore Index Performance

01. Introduction

02. Batch Mode Execution

03. Batch Mode Key Points

04. Demo - Batch Mode

05. Demo - Batch Mode on Rowstore

06. Explore Aggregate Pushdown

07. Demo - Aggregate Pushdown

08. Explore String Predicate Pushdown

09. Demo - String Predicate Pushdown

10. Adaptive Query Joins

11. Summary

6. Monitoring and Maintaining Index Health

1. Introduction

2. Data Modifications

3. Demo - Data Modifications

4. Find Fragmentation

5. Demo - Find Fragmentation

6. Fixing Fragmentation

7. Demo - Fixing Fragmentation

8. Summary

7. Building Columnstore Indexes in the Real World

1. Introduction

2. Proving out Columnstore

3. Demo - Proof of Concept Part 1

4. Demo - Proof of Concept Part 2

5. Demo - Shrink Big Tables with Columnstore

6. Demo - Loading Data with Columnstore

7. Key Takeaways

8. Continue the Journey

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight