New answers tagged

0

When you are updating Statistics I would either go with the default sample or do a fullscan. When sampling to create statistic SQL Server will navigate through the layers of the index for EACH row that it samples, whereas to do a FULLSCAN it simply scans the leaf level of the index. So even sampling 1% of a table can end up costing more than doing a FULLSCAN....


0

I would certainly do that. Only oracle knows the internals and even there I have my doubts. But there is more to do. There are a lot of settings in gather statistics. You seem to follow the brute force method. You might gain some benefits from studying the frequency of the tables, samplesizes and partitions. Involve a developer and use their knowledge about ...


Top 50 recent answers are included