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.