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 |
|
NightPassanger
Starting Member
2 Posts |
 Posted - 2010-11-30 : 04:36:48
|
| Anyone do you know a good artical about the topic : When you have a table scan or cluster index scan in execution plan what should you do ? I really have a big trouble in optimazing my queries , so any help will be appreciated :) |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-11-30 : 05:23:19
|
| What you should do? It depends. A scan is not always a problem.There are entire books on optimisation. Maybe start here:http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/--Gail ShawSQL Server MVP |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
Table scan or cluster index scan in execution plan