Hi Guest 1 HomePage 1 Jobs 1 WalkIn 1Articles  

 :) Latest Topic
SQL Query
JavaScript Questions
SharePoint Interview
general knowledge
 :) Hot Jobs
 :) Latest Articles


Write down some common difference of Row an Column store in SAP HANA?
Question Posted on 13 Oct 2021

Home >> SAP >> SAP Hana >> Write down some common difference of Row an Column store in SAP HANA?

Write down some common difference of Row an Column store in SAP HANA?
Below are the some of the common difference between Row and Column are given below:-
Row StoreColumn Store
As the name suggest it will stores table records in a sequence of rowsAnd on the other place here entries of a column stored in contiguous memory locations.
The application needs to process only one single record at one time (many selects and /or updates of single records).Calculations are typically executed on individual or a small number of columns.
The application typically needs to access the complete record.The table is searched based on the values of a few columns.
The columns contain mainly distinct values so compression rate would be low.The table has a large number of columns.
Neither aggregations nor fast searching are required.The table has a large number of rows and columnar operations are required (aggregate, scan, and so on)
The table has a small number of rows (for example, configuration tables).High compression rates can be achieved because the majority of the columns contain only a few distinct values (compared to the number of rows).

Other Important Questions
Class to calculate runtime in ABAP on HANA?
Basic definition of SAP HANA
What is SAP HANA or basic of SAP HANA
What is the full form of SAP HANA?
Can you define the term Schema in SAP HANA?

Hello Sir/Madam as Covid is spreading we request you to please take care your self and visit helpsthepoor.com

Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions
PHP | Biztalk | Testing | SAP | HR |