Q. What is the difference between Row Storage and Column Storage? Row Store Column Store Choosing table as Row Store is not as restrict as column If you see there is large amount of data and having non-unique (Repeating e.g. Material group, Material Clas.. In MARA) If there is a data set where you have unique values(distinct) Aggregation of data is required (sales order table) Not applying any aggregation on table. Always selecting FEW columns in your programs out of so many columns in table. No Aggregation like org data, configuration SELECTING all column all time.
