Welcome to Aussie SQL Server Bloggers
Sign in
|
Join
|
Help
Transaction blog
This Blog
Email
Calendar
Aug
September 2006
Oct
M
T
W
T
F
S
S
28
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
4
5
6
7
8
Search
Go
Syndication
RSS 2.0
Atom 1.0
Archives
April 2008 (4)
February 2008 (2)
January 2008 (1)
June 2007 (2)
April 2007 (4)
March 2007 (1)
December 2006 (6)
November 2006 (2)
October 2006 (1)
September 2006 (13)
August 2006 (2)
July 2006 (1)
June 2006 (2)
May 2006 (1)
April 2006 (3)
March 2006 (11)
February 2006 (3)
January 2006 (2)
November 2005 (1)
October 2005 (1)
September 2005 (1)
April 2005 (1)
March 2005 (2)
February 2005 (3)
December 2004 (5)
November 2004 (3)
October 2004 (1)
September 2004 (2)
Navigation
Home
Blogs
Photos
Post Categories
Australian SQL Server User Group (4)
Personal stuff (6)
SQL Server - other (6)
SQL Server - Scripts (9)
SQL Server - Technical (19)
Saturday, 16 September 2006 - Posts
Saturday, 16 September 2006 11:50 AM
Debunking myths about clustered indexes - part 3 (example script)
So far in this series of posts, I have discussed how clustered indexes (CIXs) can be less efficient for both bookmark lookups & range scans than non-clustered indexes (NCIXs). In this post, I'm providing a repro script that demonstrates these two
posted by
Greg_Linwood
|
2 Comments
Filed Under:
SQL Server - Technical