What is the major difference between row sparse compression with rowstore tables?
Let’s assume I have a table “emp” with 1million records and each record has 10 columns. There is no null value for any of the columns (I am trying to say all are not null columns).
Is there any advantage I get if I use the rowstore with sparse compression? If yes, what it is?