InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Table Type Is Preferred In Sap Hana Administration: Column-based Or Row-based? |
|
Answer» Since analytic APPLICATIONS REQUIRE massive aggregations and agile data processing, column-based tables are preferred in SAP HANA as the data in column is stored consequently, one after the other enabling faster and easier readability and retrieval. Thus, columnar storage is preferred on most OLAP (SQL) queries. On the CONTRARY, row-based tables force users to read and access all the information in a row, even though you require data from few and/or specific columns. Since analytic applications require massive aggregations and agile data processing, column-based tables are preferred in SAP HANA as the data in column is stored consequently, one after the other enabling faster and easier readability and retrieval. Thus, columnar storage is preferred on most OLAP (SQL) queries. On the contrary, row-based tables force users to read and access all the information in a row, even though you require data from few and/or specific columns. |
|