The overhead of a non-unique clustered index - Andrew Calvett

The overhead of a non-unique clustered index

Published Monday, October 20, 2008 12:21 AM

This blog has been migrated to blog.calvett.co.uk. Please update your feeds.
This post can be found here.

Comments

# Christian said on Tuesday, October 21, 2008 7:52 PM

Hi Andrew,

Its probably worth re-iterating that the uniqueifier (you have to love the MS devs for inventing new words) is only applied to non-unique rows not EVERY row.

I didn't know about the variable offset though, good call!

Christian Bolton

sqlblogcasts.com/.../christian

# ACALVETT said on Wednesday, October 22, 2008 12:38 PM

Hi Christian,

Thanks for your input. I've updated the post to make sure that its clear!

Cheers

Andrew

# Log Buffer #120: a Carnival of the Vanities for DBAs said on Friday, October 24, 2008 5:25 PM

Pingback from  Log Buffer #120: a Carnival of the Vanities for DBAs