Understanding and using indexes on SQL Server

SQL Server, like most RDBMS systems provides index functionality to massively speed up database queries. In this guide, I will introduce you to what indexes are, how a clustered index differs from a non-clustered index and in what ways they do and don't provide performance benefits.

The theory generally applies to other relational databases also.

[davidk]

Honestly, I'm just happy to have found someone whose accent I can understand.

[daniellee]

There needs to be more tutorials with this style and format. Rigorous, academic texts with large amounts of jargon and time complexity proofs are important, particularly once you have mastered a topic and want marginal speed and memory improvements to complex stored procedures. However, when you are starting out, having complex ideas boiled down to simple English and having clear instructions showing you how to tell when things are working well and when they are not are so important. Thank you

[samilsadqov]

At last, I understood all this index-related magic. Thank you sir! That was a huge dependency injection of valuable information in my constructor.

[MCNeko]

32:30 - Location to create an index.
38:00 - Including columns = faster retrieval of data in the included column (SELECT) when searching by the key column (WHERE). Also allows for ranges in the WHERE clause.
41:45 - Adding additional columns to the key columns for indexing.

[robvaughan]

Superb video! Well presented, easy to follow and extremely informative. Thanks Luke.

[thaihiepbui]

So hepful with an example. Thanks a lot Luke!

[regUser]

I've learnt so much. Very easy to understand.

[vijaybodkhe]

This was a really helpful video. Thanks a lot for sharing such a valuable piece of information

[LazarakisSokratis]

Very helpful and easy to understand . Thank you

[mrpotatoh]

This video was super useful for understanding this. Thanks!

[ankolbi]

Great Video. Well explaned :) Thank you

[dgh]

pls drop us or link to the procSizeStats?