Database Clustered vs Non-Clustered Index

Database Clustered vs Non-Clustered Index, Heap-Organized tables vs Index-Organized tables, RowId tables, pages and fragmentation are some of the topics covered in this video.

Learn how a Database works under the hood, and the differences and benefits of the Heap-Organized table vs an Index Organized Table.
Understand how a Non-Clustered index is represented depending on the type of the storage, and the advantages or disadvantages compared to a Clustered Index.
Lean how a database page gets fragmented, and how a B+Tree works internally.

Chapters:
0:00 Intro
0:07 Database Page
0:42 Heap-Organized Tables
0:52 Non-Clustered Index on top of a Heap-Organized Table
2:00 Clustered Index
3:05 Non-Clustered Index on top of a Index-Organized Table
3:35 RowId Tables
4:23 Fragmentation
5:18 Fragmentation on a B+Tree
6:19 Large Rows - TEXT and BLOB fields
6:50 Heap-Organized Tables Benefits
7:38 Index-Organized Tables Benefits

#database #backend #sql #codingtips #programming #databases #databasedesign #backenddeveloper

[QianyuHuang-du]

this is an amazing video ever! watched so many videos and yours is the first one which explains the logic well!

[dyna]

You have covered almost everything with good animations.

[piotrbeda]

Best explanation of indexes on YT I've ever seen

[theboringdev]

I wish your video will reach more viewers.