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-06-10 : 09:30:00
|
| Deam Diaz writes "I am, a SQL Server 6.5 (over NT 4.0 SP 6) administrator, and i need to create statistics on "ALL" the colums of an clustered index in order to increase de performace of my querys.This is an ease task on SQL 7 (+), but i don't know how to acomplish it on 6.5.Do you know how to do this, or some alternate solution (I can´t migrate now).I apolagize about my english, and thanks you for your help." |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-06-10 : 10:45:35
|
| If memory serves, Statistics are new to SQL 7. So there is no way to create statistics in SQL 6.5. Just rebuild your indexes and that should be all you need.Jeff BanschbachConsultant, MCDBA |
 |
|
|
|
|
|
CREATING STATISTICS ON SQL Server 6.5