B-Tree for indexes with included column

Chaitanya Kiran 696 Reputation points

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

    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

    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