Share via

B-Tree for indexes with included column

Chaitanya Kiran 776 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.
13,361 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bruce (SqlWork.com) 61,731 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
  2. LiHongMSFT-4306 25,651 Reputation points
    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