A virtually hashed table contains a “hashed” region and an “overflow” region. The hashed region stores the hashed rows, and the overflow region stores the remaining rows. You can access the overflow region with a regular clustered index scan using a B-tree clustered index.
This figure demonstrates accessing the overflow region with a root page.
The first data page, the root page, and the first overflow page of a virtually hashed table are created when you create the table. SYSINDEXES.indroot is the root page for the overflow clustered region. The first leaf page under this page is the first overflow page. SYSINDEXES.indfirst points to the first data page, so a table scan starts at the beginning of the table and scans the entire table.