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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-03 : 09:03:27
|
| Aaron writes "Hi,Where is a good place to find out what the "things" in an exection plan are, and whether they are good or bad in SQL2000?I repeatedly get clustered index scans and seeks and bookmarkup lookups, i know what some of them are, but dont know if they are good or bad or if they need attention.many thanks" |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-07-03 : 09:15:55
|
Do a search in Books On Line for any specific definitions you have questions on. To get you started on what to look for...table scan =  index scan =  index seek =  hth,Justin |
 |
|
|
dsdeming
479 Posts |
Posted - 2002-07-03 : 09:17:05
|
| Take a look at "Graphically Displaying the Execution Plan Using SQL Query Analyzer" in BOL. It has short descriptions of all the physical operators used by SQL Server.Edited by - dsdeming on 07/03/2002 09:18:32 |
|
|
|
|
|
|
Execution Plans