Database Clustered vs Non-Clustered Index
ฝัง
- เผยแพร่เมื่อ 20 พ.ค. 2024
- 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.
Slides are available at: speakerdeck.com/matteobertozz...
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 - วิทยาศาสตร์และเทคโนโลยี
Best explanation of indexes on YT I've ever seen
Thank you, I really appreciate!
I wish your video will reach more viewers.