Тёмный

Understanding and using indexes on SQL Server 

Luke Briner
Подписаться 4,6 тыс.
Просмотров 25 тыс.
50% 1

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.

Опубликовано:

 

22 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 23   
@davidk7212
@davidk7212 2 года назад
Honestly, I'm just happy to have found someone whose accent I can understand.
@daniellee2883
@daniellee2883 3 года назад
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
@samilsadqov479
@samilsadqov479 3 года назад
At last, I understood all this index-related magic. Thank you sir! That was a huge dependency injection of valuable information in my constructor.
@robvaughan6649
@robvaughan6649 Год назад
Superb video! Well presented, easy to follow and extremely informative. Thanks Luke.
@thaihiepbui1599
@thaihiepbui1599 Год назад
So hepful with an example. Thanks a lot Luke!
@ahmad23232
@ahmad23232 3 года назад
Big thanks! that was super useful.
@tomfirth2538
@tomfirth2538 4 года назад
Great video, thank you Luke.
@anildhage
@anildhage Год назад
Most underrated video
@regUser123
@regUser123 2 года назад
I've learnt so much. Very easy to understand.
@soumikmishra7288
@soumikmishra7288 3 года назад
Thanks for this great video Luke
@LazarakisSokratis
@LazarakisSokratis 2 года назад
Very helpful and easy to understand . Thank you
@vijaybodkhe8379
@vijaybodkhe8379 2 года назад
This was a really helpful video. Thanks a lot for sharing such a valuable piece of information
@marcinjarzebski9446
@marcinjarzebski9446 2 года назад
Very helpful, thank you Luke
@behradnafar7214
@behradnafar7214 3 года назад
That was very useful, Thanks
@MCNeko6554
@MCNeko6554 2 года назад
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.
@mrpotatoh
@mrpotatoh 2 года назад
This video was super useful for understanding this. Thanks!
@LukeBriner
@LukeBriner 2 года назад
Glad it was helpful!
@ankolbi
@ankolbi Год назад
Great Video. Well explaned :) Thank you
@srinivasvasu916
@srinivasvasu916 3 года назад
Great video 👍
@ribalassaf8525
@ribalassaf8525 2 года назад
LEGEND man!
@rjtmhy
@rjtmhy 3 года назад
Learnt a lot! thanks Luke:)
@expukpuk
@expukpuk Год назад
Ok, but too much talking
@dgh25
@dgh25 Год назад
pls drop us or link to the procSizeStats?
Далее
Deadlocks: Lets Do One, Understand It, and Fix It
44:01
SQL Server Index Internals: A Deep Dive
1:14:34
Просмотров 32 тыс.
Database Indexing for Dumb Developers
15:59
Просмотров 59 тыс.
Fragmentation Explained in 20 Minutes
18:40
Просмотров 13 тыс.
Watch Brent Tune Queries - SQLSaturday Oslo
1:01:54
Просмотров 45 тыс.
How do indexes make databases read faster?
23:25
Просмотров 65 тыс.
Microsoft SQL Server Performance Tuning, Live
54:30
Просмотров 115 тыс.