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.
| Author |
Topic |
|
swordfish
Starting Member
11 Posts |
 Posted - 2003-06-02 : 10:27:15
|
| I'm looking for a good resource, preferably online, that describes how to read and decipher the graphical execution plan in Query Analyzer. Some of the things I understand, but I'm unsure about the difference between Scans and Seeks, and exactly what a Nested Loop and Merge Joins are. Can anyone point me in the right direction?Ta much! |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-02 : 10:31:24
|
| Did you try BOL (Books Online)?Scane are usually bad, and sometime unavoidable....the real answer is:It Depends(did I say I love that answer)...Brett8-) |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-06-02 : 11:38:42
|
| You can get a lot of this by creating a table or two with indexes and looking at the plans of queries on them.try this to startcreate table #a (i int, j int)create index ix on #a (i)select * from #a where i = 1select * from #a where j = 1select i from #a where i = 1select j from #a where j = 1==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Nazim
A custom title
1408 Posts |
|
|
swordfish
Starting Member
11 Posts |
Posted - 2003-06-03 : 06:18:38
|
| Thanks folks, I'll try these out.Cheers! |
|
|
|
|
|
|
How to read the execution plan