Hi,

we have a problem with the statistics in SQL Server 2000.
We frequently truncate and fill some tables.
But SQL server appear to not update the statistics and then our queries are
very very slow !
but our auto update stats is ON

so we are disapointed :-)

for the moment we'll force SQL Server to update its stats, but why the auto
update doesn't work?
does the statistics can't handle truncate (or delete *) statements
correctly?

if we force the update of the stats, when its better to do this? after we
truncate the tables? after? or maybe its better to completly destroy any
stats and let SQL Server to recreate these stats automatically?

thanks for you help and guide.

Jerome.