We have several "big" tables in our data warehouse. After each ETL we gather stats on the tables. Each of the table has partition and sub-partition. The complete process of gathering stats is taking hours to finish. currently, this is what we do for each table.
Do you recommend us doing the following as recommended at
There are a number o commands mentioned in the link.
Yes, try all of them, and do the one that works for you.
Great suggestion Top_gun!