We have a large table that's partitioned by date on weekly basis. Runnning update statistics on it takes significant amount of time. I want to find a solution that will update statistics only for last 6 partitions (because only last 6 in our environment can be inserted/deleted records).
I checked B.O.L., it does not have anything for that. But I feel there are should be some tricks, workarounds for that. Has anybody experienced same problem ?
Thanks in advance.