What is an Index Scan?

This video explains what an index scan is when looking at a query plan.

I'm currently working for FM Global, an industry leading engineering & insurance company, as a DBA. I've done development of large scale applications in languages such as VB, C# and Java. I've worked in SQL Server from the hoary days of 6.0. My nickname at work is the "The Scary DBA." I even have an official name plate with it. I wear it proudly. I was awarded a Microsoft MVP in April of '09.

C Piontek on 10/7/2008

to the point. Index versus table and the benefit of index

R Wong on 10/7/2008

A follow up showing what the % could be like if, let say, the where clause is added or adjust. That will give a better feel of the degree of improvement as a result of the change.

Grant Fritchey on 10/7/2008

That's a good idea. I'm pretty sure Andy & Co. are working out mechanisms for us to submit new videos. That would be worth following up.

iskarta on 10/8/2008

It's not enough

Jack C. Donnell on 10/8/2008

Very good. Might want to add one about the XML Execution plan and how it suggests an coluns and includes for an index to make the query run faster. Just Caution user not to blindly create the indexes..

Grant Fritchey on 10/9/2008

I did one on XML, but it doesn't include anything about the missing index hints. http://www.jumpstarttv.com/xml-execution-plans_373.aspx

Chuck Myers on 10/10/2008

OK, but what is an index scan? The video says it's bad to scan large numbers of rows, but what can we do about it?

badra on 10/22/2008

gd

Michael on 10/29/2008

Needs more focus on the solutions.

James Mount on 11/6/2008

Video doesn't explain what an index scan is. It compares it to table scans and some other scan, but doesn't bother to define those either. This (and most) of JumpstartTV's videos are worthless and I will probably stop wasting my time on them.

Carlos E. Mosquera on 12/26/2008

I think like Michael!

John on 4/22/2009

Thanks!

Jimmya11 on 8/6/2009

more detail could have been given

Steven Robinson on 12/30/2011

Great insight