B-Tree for indexes with included column

Chaitanya Kiran 696 Reputation points
2024-03-24T15:05:34.15+00:00

How B-Tree forms for indexes with included column?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,654 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Bruce (SqlWork.com) 55,196 Reputation points
    2024-03-24T15:52:49.4166667+00:00

    The included column(s) data is stored in the leaf node where only key data is stored in the inner and root nodes,

    0 comments No comments

  2. CosmogHong-MSFT 22,621 Reputation points Microsoft Vendor
    2024-03-25T03:14:05.4233333+00:00

    Hi @Chaitanya Kiran

    Index key columns are part of the b-tree of the index. While included columns are not.

    Best regards,

    Cosmog Hong


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments