Does anyone know if there is a FAQ entry on how turning on auto
create/udpate statistics in SQL Server 7.0 for tables affects insert
performance? Migrating from 6.5 -> 7.0 and using these options has
increased the performance on 'select based' queries, but big inserts
(not BCP or BULK INSERT) have slowed noticably.
As I understand from the docs, even though when you do a sp_help on a
table and all the auto created statistics show as non-clustered
indices, they are actually statistics objects..