Quickest way to apply SPARSE on huge existing tables
2
votes
0
answers
242
views
I have a bunch (> 40) of columns in a huge table (> 27 m records) which I am attempting to set as SPARSE. Each column takes up to 40 minutes to be altered. Is there a way to do this more quickly? Is there some metadata I can modify to quickly set these columns as SPARSE and rebuild the table?
Asked by sciron
(21 rep)
Jul 30, 2019, 02:14 PM