|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 2:21 AM
Points: 14,804,
Visits: 10,597
|
|
Comments posted to this topic are about the item Introduction to Indexes
Gail Shaw
We walk in the dark places no others will enter
We stand on the bridge and none may pass
|
|
|
|
|
SSChasing Mays
Group: General Forum Members
Last Login: Tuesday, November 17, 2009 5:46 AM
Points: 648,
Visits: 813
|
|
Amazing Gail...
I have been looking for an article on Indexes as simple and exhaustive as this for long.
Looking forward to the next 2 parts.
Thanks
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, November 03, 2009 9:37 AM
Points: 3,
Visits: 5
|
|
thanks Gail...
waiting for ur next post ...
please elaborate on the clustered & non clustered indexes & implementation of it in actual db
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 2:21 AM
Points: 14,804,
Visits: 10,597
|
|
omkarred (10/26/2009)
please elaborate on the clustered & non clustered indexes & implementation of it in actual db
That's what parts 2 and 3 cover.
Gail Shaw
We walk in the dark places no others will enter
We stand on the bridge and none may pass
|
|
|
|
|
SSCertifiable
Group: General Forum Members
Last Login: Tuesday, November 17, 2009 8:32 PM
Points: 6,799,
Visits: 13,363
|
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Yesterday @ 9:57 AM
Points: 7,
Visits: 124
|
|
Thankyou for this, the best I have read so far, all makes sense, looking forward to the next parts
Rog
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 5:56 PM
Points: 1,469,
Visits: 2,049
|
|
Truly a case where pictures are worth thousands of words. Nicely done.
Best,
TheSQLGuru
SQL Server MVP
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Wednesday, November 18, 2009 6:15 AM
Points: 1,720,
Visits: 590
|
|
Thanks Gail for mentioning that "When an index scan is done on the clustered index, it’s a table scan in all but name." Many folks think that performance is always better with clustered index scan than a table scan.
|
|
|
|
|
SSChampion
Group: Administrators
Last Login: Yesterday @ 4:30 PM
Points: 21,860,
Visits: 6,079
|
|
Excellent job, Gail!
We're publishing part 2 in a couple weeks and part 3 as soon as possible after that.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Yesterday @ 9:50 AM
Points: 1,
Visits: 7
|
|
This article is fortuitous for me since I attended a SQL 2008 Development class on Saturday and this topic was covered most of the afternoon.
Thanks for the review. 
|
|
|
|
