author | ms.author | ms.reviewer | ms.date | ms.service | ms.topic |
---|---|---|---|---|---|
MikeRayMSFT |
mikeray |
randolphwest |
09/29/2024 |
sql |
include |
Note
Documentation uses the term B-tree generally in reference to indexes. In rowstore indexes, the Database Engine implements a B+ tree. This does not apply to columnstore indexes or indexes on memory-optimized tables. For more information, see the SQL Server and Azure SQL index architecture and design guide.