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 0.51 Mb.
View original pdf
Page2/48
Date07.04.2021
Size0.51 Mb.
#56254
1   2   3   4   5   6   7   8   9   ...   48
AOH INTERVIEW QUESTIONS
MTS Auth ISSUES
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 0.51 Mb.

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




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

    Main page