Share via

B-Tree for indexes with included column

Chaitanya Kiran 801 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.
14,493 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bruce (SqlWork.com) 76,181 Reputation points Moderator
    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 31,551 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.