SentryOne Team Blog (blogs.sentryone.com)

Tag : allocation order scans

Paul White : Allocation Order Scans

Paul White (@SQL_Kiwi) explains various ways SQL Server makes runtime decisions about whether to use the b-tree structure or perform allocation order scans.