Printed 2015/10/05 02:41AM

Row of nonclustered index page

By jamesxu98918, 2013/01/04

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.

Copyright © 2002-2015 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.