Can explain difference and details between 'Index Scan' and 'Index seek' in Query plan?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Can explain difference and details between...

Can explain difference and details between 'Index Scan' and 'Index seek' in Query plan?

Rate Topic

Display Mode

Topic Options

Author

Message

Paresh Prajapati

Posted Tuesday, January 01, 2008 2:37 AM

Old Hand

Group: General Forum Members
Last Login: Friday, August 31, 2012 6:08 AM
Points: 322, Visits: 459

Can explain difference and details between 'Index Scan' and 'Index seek' in Query plan?

_____________________________________________________________________________________________________________
Paresh Prajapati

+919924626601
http://paresh-sqldba.blogspot.com/
LinkedIn | Tweet Me | FaceBook | Brijj

Post #437708

GilaMonster

Posted Tuesday, January 01, 2008 3:26 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 37,742, Visits: 30,021

http://sqlinthewild.co.za/index.php/2007/11/15/execution-plan-operations-scans-and-seeks/

If you still have any questions, post them and I'll be happy to help.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #437713

Jeff Moden

Posted Tuesday, January 01, 2008 8:42 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 32,923, Visits: 26,811

Another great summary! Great work, Gail.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #437738

GilaMonster

Posted Tuesday, January 01, 2008 8:52 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 37,742, Visits: 30,021

:) Thanks.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #437740

tilak_majety

Posted Friday, June 22, 2012 4:03 AM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 4:17 AM
Points: 14, Visits: 382

Good one :)

Post #1319852

jswong05

Posted Monday, June 25, 2012 2:56 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, March 18, 2013 7:54 AM
Points: 27, Visits: 421

Grant Fritchey's ebook from redgate ---- you must read.

Jason
http://dbace.us
Tongue

Post #1320894

« Prev Topic | Next Topic »

Permissions