Q. What is the difference between Row Storage and Column Storage? Row Store


Q. What is the difference between Row Storage and Column Storage?



Download 156.8 Kb.
View original pdf
Page2/48
Date07.04.2021
Size156.8 Kb.
1   2   3   4   5   6   7   8   9   ...   48
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.

Download 156.8 Kb.

Share with your friends:
1   2   3   4   5   6   7   8   9   ...   48




The database is protected by copyright ©ininet.org 2020
send message

    Main page