posted on Tuesday, June 26, 2007 1:51 PM
by
SimonSabin
To cluster of not
My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/To cluster of not
The new RSS feed is here
Tony's blogged about the use of heaps http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/06/24/row-fragmentation-hopscotch-heap-v-clustered-and-io-cost.aspx.
Whilst this highlights data on a page being out of sequence and thus yoyoing
when you scan the data, it doesn't mean you should always have a clustered
index.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/To cluster of not