Display Estimated Execution Plan -- Need more info

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Display Estimated Execution Plan -- Need more info

Author

Topic

wkm1925
Posting Yak Master

207 Posts

Posted - 2009-12-23 : 14:03:10

After run a SQL in New Query and get a result, me looking into Display Estimated Execution Plan.

What's the meaning of
1. Index Scan
2. Index Seek
3. Lookup

My findings is Lookup indicate more cost ($)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-23 : 14:12:00

1. It had to scan each row in the index to find the matches.
2. It only had to seek out the rows, so it had less work to do.
3. It had to go to another index to find some of the data.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

wkm1925
Posting Yak Master

207 Posts

Posted - 2009-12-23 : 14:17:17

tq very much

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-12-23 : 16:10:43

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

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources