November 7, 2012 at 11:30 am
Hi,
I an wondered why Include column does not change the size of non-clustered index.
As I know non-clustered index is combination of leaf and non-leaf noedes, and include column are stored in leaf node only, and if create a non-clustered index it effect the space used by respective table.
So why include column does not increase the size of non-clustered index size.
Please help me to understand this.
Thanks
Kuldeep panwar
November 7, 2012 at 11:50 pm
Include columns will increase the size of nonclustered indexes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 8, 2012 at 4:22 pm
So why it is called that Include column does not increase non-cluster index size......
November 8, 2012 at 4:25 pm
It will increase the size of the index, but only for leaf pages. The non-leaf pages of the index will be the same size as before.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 8, 2012 at 7:56 pm
panwar.jt (11/8/2012)
So why it is called that Include column does not increase non-cluster index size......
Where is that stated?
Include columns won't increase the size of the index key (they're not part of the index key), but they will increase the size of the index as a whole.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply