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

The overhead of a non-unique clustered index

Published 20 October 2008 00:21

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

by ACALVETT
Filed under: , , ,

Comments

# Christian said on 21 October 2008 19:52

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 22 October 2008 12:38

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 24 October 2008 17:25

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