Subscribe to this blog
Briefcase
Print
so unique non-clustered index created on unique clustered index use smallest space, while non-unique non-clustered index created on non-unique clustered index use largest space.
James' SQL Footprint
Love SQL Server, Love life.
Row of nonclustered index page
Below is the formula of calculating the row size of non-clustered index page
so unique non-clustered index created on unique clustered index use smallest space, while non-unique non-clustered index created on non-unique clustered index use largest space.
so unique non-clustered index created on unique clustered index use smallest space, while non-unique non-clustered index created on non-unique clustered index use largest space.
Comments
Leave a comment on the original post [jamessql.blogspot.com, opens in a new window]
Loading comments...