Statistics on Small Tables May Not be Populated in SQL Server 2000

This is a problem I believe I have run into, but never was able to get any more information on it. It appears, from this blog entry, that small tables (under 500 rows) will not have their statistics automatically updated. In some scenarios, the lack of statistics on these smaller tables can make a difference. I have seen a couple of situations where updating statistics on small tables have resulted in big gains. So, no matter the size of tables involved in a problem query, one step towards solution might be updating manually statistics on all of the tables, even tiny ones.

Posted by Douglas Reilly at 08:33 AM  Permalink