Introduction to Indexes

Author	Message
GilaMonster	GilaMonster Posted 8 years ago #808389
SSC Guru Group: General Forum Members Points: 228665 Visits: 46343	Comments posted to this topic are about the item Introduction to Indexes Gail Shaw Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci) SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability We walk in the dark places no others will enter We stand on the bridge and no one may pass 8
	Quote
rosh-396756	rosh-396756 Posted 8 years ago #808541
Ten Centuries Group: General Forum Members Points: 1018 Visits: 930	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 6
	Quote
omkarred	omkarred Posted 8 years ago #808552
SSC Rookie Group: General Forum Members Points: 25 Visits: 5	thanks Gail... waiting for ur next post ... please elaborate on the clustered & non clustered indexes & implementation of it in actual db 9
	Quote
GilaMonster	GilaMonster Posted 8 years ago #808560
SSC Guru Group: General Forum Members Points: 228665 Visits: 46343	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 Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci) SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability We walk in the dark places no others will enter We stand on the bridge and no one may pass 8
	Quote
Grant Fritchey	Grant Fritchey Posted 8 years ago #808618
SSC Guru Group: General Forum Members Points: 99653 Visits: 33014	Excellent introduction. Nice job Gail. Couldn't ask for better. ---------------------------------------------------- The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt The Scary DBA Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans Product Evangelist for Red Gate Software 8
	Quote
roger_os	roger_os Posted 8 years ago #808650
SSC Veteran Group: General Forum Members Points: 201 Visits: 568	Thankyou for this, the best I have read so far, all makes sense, looking forward to the next parts Rog 8
	Quote
TheSQLGuru	TheSQLGuru Posted 8 years ago #808652
SSC-Dedicated Group: General Forum Members Points: 32805 Visits: 8677	Truly a case where pictures are worth thousands of words. Nicely done. Best, Kevin G. Boles SQL Server Consultant SQL MVP 2007-2012 TheSQLGuru on googles mail service 7
	Quote
Noel McKinney	Noel McKinney Posted 8 years ago #808662
SSCrazy Group: General Forum Members Points: 2263 Visits: 798	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. 7
	Quote
Steve Jones	Steve Jones Posted 8 years ago #808674
SSC Guru Group: Administrators Points: 148641 Visits: 19446	Excellent job, Gail! We're publishing part 2 in a couple weeks and part 3 as soon as possible after that. Follow me on Twitter: @way0utwest Forum Etiquette: How to post data/code on a forum to get the best help My Blog: www.voiceofthedba.com 6
	Quote
david.stein-1140863	david.stein-1140863 Posted 8 years ago #808745
SSC Rookie Group: General Forum Members Points: 29 Visits: 155	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. :-) 6
	Quote

Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.

You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.