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 |
|
scottpt
Posting Yak Master
186 Posts |
 Posted - 2005-05-16 : 15:10:51
|
| When would you use Create Statistics over an index? |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-05-16 : 21:20:28
|
| When you have missing statistics, but either don't need an index, or already have one. ???? Normally, it's better to let SQL Server create statistics where it thinks appropriate.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Create Index vs Create Statistics