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 |
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
 Posted - 2010-09-27 : 12:48:55
|
| I have an index called ix_Classes_CourseID. It has 133000 user seeks and 23000 user scans. Does the presence of user scans indicate that the index is slightly wrong or that an additional index is needed. My interpretation is that maybe an "included column" is missing causing the index to have to do a scan after the seek in order to get the additional information. Is that a correct?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Question about index scans