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 |
|
ServerTeam
Yak Posting Veteran
83 Posts |
 Posted - 2008-04-15 : 09:17:57
|
| Hi Gurus,I need you update statistics on table .Is there any command or stored procedure for this.Thanks,ServerTeam |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-04-15 : 10:55:44
|
UPDATE STATISTICS tablename (or index name). See BOL for more info.Edited - Sorry, this is for SQL 2000. Might be the same in SQL 2005. I should've checked which forum I was in  Terry |
 |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-04-15 : 12:00:20
|
| In SQL Server 2005, I'd recommend using the sp_updatestats procedure over the UPDATE STATISTICS command. They both will accomplish the same goal, however sp_updatestats has been optimized in 2005 to only update statistics if certain thresholds are exceeded. |
|
|
|
|
|
|
update statistics on table