• @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