Database Clustered vs NonClustered Index, HeapOrganized tables vs IndexOrganized 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 HeapOrganized table vs an Index Organized Table.
Understand how a NonClustered 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: https://speakerdeck.com/matteobertozz...
Chapters:
0:00 Intro
0:07 Database Page
0:42 HeapOrganized Tables
0:52 NonClustered Index on top of a HeapOrganized Table
2:00 Clustered Index
3:05 NonClustered Index on top of a IndexOrganized 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 HeapOrganized Tables Benefits
7:38 IndexOrganized Tables Benefits
#database #backend #sql #codingtips #programming #databases #databasedesign #backenddeveloper