@henrik.thomsen.dk
This make sense!
I use incremental stats where possible (partitioned tables).
With a small script, which determines the amount of changed rows in the partitions. If there are enough changes I update the stats of the partition.
In the really big tables (gt. 3TB) 10% are a good measure for good plans (in our environment)
Gerhard P.Advanced BI DeveloperAustria