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. Paul White ◆ January 23, 2015 11