Hello, SQL 2016 to save space we are aiming to do compression on Tables & their Indexes.
Is there any specific order which to run compression first Table first then Indexes or Indexes first and then Tables?
Anything else to be aware or make note of?
Thanks in advance.