Welcome to Aussie SQL Server Bloggers Sign in | Join | Help

Monday, 11 September 2006 - Posts

Debunking myths about clustered indexes - part 2 (CIXs are NOT better for range scans)

In my previous post on this topic, I discussed the ineffiency associated with performing bookmark lookups between Non-Clustered Indexes (NCIXs) and Clustered Indexes (CIXs), as opposed to when those same lookups are made from NCIXs to HEAP storage. Although

In a New York state of mind...

Hard to believe 5 years have flown by. Still makes me angry remembering those poor people desperately jumping off the towers..
posted by Greg_Linwood | 0 Comments