Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update_Statistics very slow

Status
Not open for further replies.
Tison

Tison

Programmer
May 12, 1999
216
0
0
CH
I have a table of over 1 million records and the update_statistics command runs for many hours on it - even seems to hang at times.
How can I improve this ?
Are there any parameter settings that will help ?
 
Status
Not open for further replies.

Similar threads

mark1110
  • Locked
  • Question
Sybase 11 to Sybase 15 slowness
Replies
0
Views
17
mark1110
mark1110
jwiebe
  • Locked
  • Question
Very slow Queries/Strange behaviour upon selecting fields
Replies
1
Views
18
mrmitchmitchell
mrmitchmitchell
eoghan07l
  • Locked
  • Question
Database running slow
Replies
2
Views
16
eoghan07l
eoghan07l
crystalReporterNew
  • Locked
  • Question
stored procedure slow
Replies
1
Views
15
micha123
micha123
Tison
  • Locked
  • Question
How can I speed up "update_statistics"
Replies
0
Views
16
Tison
Tison

Part and Inventory Search

Sponsor

Back
Top