SQL Server Internals: HEAPS VS. CLUSTERED INDEXES!
@SQLBalls walks us through the age old fight of Heaps vs. Clustered Indexes!?! ....to be honest it's only a fight because the default table type of Oracle is a Heap, SQL Server is a Clustered Index. Both have good uses in SQL Server, but it is importiant to understand what those uses are and when to use them.
That's what we will walk through, the internal structure, the overhead, and some use cases. There is no code demo, we kept this conceptual and the follow up video will have the demos.
Links:
Heaps (Tables without Clustered Indexes)
https://learn.microsoft.com/en-us/sql...
Clustered and nonclustered indexes described
https://learn.microsoft.com/en-us/sql...
Chapters
00:00 Introduction
00:15 About TFTF
00:36 Heaps vs. Clustered Indexes
01:12 Table Types
01:36 Data Pages
01:51 Small Overview of IAM Pages
02:19 Internals of Heaps
03:02 Internals of Clustered Indexes
05:04 Clustered Index Example
06:50 Non-Clustered Indexes
07:49 Wrap Up
Watch video SQL Server Internals: HEAPS VS. CLUSTERED INDEXES! online without registration, duration hours minute second in high quality. This video was added by user Tales From The Field 05 April 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 666 once and liked it 29 people.