Improve SQL Performance w/ Indexes

Get my Modern Data Essentials training (for free) & start building more reliable data architectures

-----

If you want a simple way to stand out as a great developer, find a way to make something run faster.

And when it comes to SQL, a great way to accomplish this is by properly using indexes.

But I also know from experience that this topic can be a bit confusing

So in this video I want to break down the two primary types of indexes you’ll come across

After watching, you'll feel more comfortable with the concept and start identifying places to add them in your database.

Timestamps:
0:00 - Intro
0:27 - What is an Index?
1:19 - Clustered Indexes
2:44 - Non-Clustered Indexes
4:11 - Things to Consider

Title & Tags:
Improve SQL Performance w/ Indexes | Performance Tuning | Clustered Index and Non Clustered Index
#kahandatasolutions #dataengineering #sqlperformance

[KahanDataSolutions]

Get my Modern Data Essentials training (for free) & start building more reliable data architectures

[dalton_hfg]

Great explanation, thanks.

I'm moving from an analyst position to the data engineering side, and your videos have been very helpful.

[TanjilulA]

Great video! The impact would have been greater if a demo was shown in addition to the explanation.

[viniciusuliana]

I'm work in data warehouse solutions. Can you talk about indexes in DW? Generally, I create index using the most commons FK's joins e use include option with the most commom measures in non clustered indexes. Is it a good pratice? Thank you!

[ДмитрийЛопатин-дю]

Thank you, not abundant, clear and precise explanation.