USE AtlantisDB GO SELECT 'UPDATE STATISTICS ['+t.TABLE_SCHEMA+'].['+o.NAME+'] WITH FULLSCAN, MAXDOP=16;' AS TabloAdi, i.rowcnt AS KayitSayisi FROM sysindexes AS i INNER JOIN sysobjects AS o ON i.id = o.id INNER JOIN INFORMATION_SCHEMA.TABLES T ON T.TABLE_NAME=o.name WHERE i.indid < 2 AND OBJECTPROPERTY(o.id, 'IsMSShipped') = 0 ORDER BY o.name ASC
UPDATE STATISTICS [dbo].[sysdiagrams] WITH FULLSCAN, MAXDOP=16;