slow table in database [Archive]

View Full Version : slow table in database

Xavier Houppertz

04-17-01, 08:20

hello,

I have a database with 20 tables. When querying, one has suddenly become very slow. It is the biggest one (100.000 rows, 17MB).

Any ideas ?
Xavier

Brian Ceccarelli

04-17-01, 09:51

If it has "suddenly" become really slow, you must do an

update all statistics TABLENAME

This will fix you up!

You need to update your statistics on all your tables often--at least once a week.

Brian

Bret Halford

04-17-01, 12:08

Have you followed the general investigation steps discussed in the whitepaper on analyzing and resolving optimizer problems at http://my.sybase.com/detail?id=2602?

bret