Introduction to Indexes

Author	Message
GilaMonster	GilaMonster Posted 9 years ago #808389
SSC Guru Group: General Forum Members Points: 845858 Visits: 48504	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 19
	Quote
rosh-396756	rosh-396756 Posted 9 years ago #808541
SSCommitted Group: General Forum Members Points: 1944 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 20
	Quote
omkarred	omkarred Posted 9 years ago #808552
SSC Rookie Group: General Forum Members Points: 41 Visits: 5	thanks Gail... waiting for ur next post ... please elaborate on the clustered & non clustered indexes & implementation of it in actual db 17
	Quote
GilaMonster	GilaMonster Posted 9 years ago #808560
SSC Guru Group: General Forum Members Points: 845858 Visits: 48504	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 16
	Quote
Grant Fritchey	Grant Fritchey Posted 9 years ago #808618
SSC Guru Group: General Forum Members Points: 334754 Visits: 33962	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 19
	Quote
roger_os	roger_os Posted 9 years ago #808650
SSChasing Mays Group: General Forum Members Points: 635 Visits: 568	Thankyou for this, the best I have read so far, all makes sense, looking forward to the next parts Rog 16
	Quote
TheSQLGuru	TheSQLGuru Posted 9 years ago #808652
SSC Guru Group: General Forum Members Points: 114711 Visits: 8972	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 15
	Quote
Noel McKinney	Noel McKinney Posted 9 years ago #808662
Hall of Fame Group: General Forum Members Points: 3057 Visits: 799	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. 21
	Quote
Steve Jones	Steve Jones Posted 9 years ago #808674
SSC Guru Group: Administrators Points: 546010 Visits: 20703	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 11
	Quote
david.stein-1140863	david.stein-1140863 Posted 9 years ago #808745
SSC Journeyman Group: General Forum Members Points: 75 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. :-) 14
	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.