Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of column based tables and row-based tables? : hana modeling
- 1 Answers
- 98 Views
- I also Faced
- E-Mail Answers
Answer Posted / Sabadar Ali
Advantages of Column Based Tables:n1. Compression: Columnar data storage allows for more efficient compression, as columns with similar values can be compressed together.n2. Query Performance: Queries that involve aggregation or filtering on a small number of columns can run faster in columnar databases since the relevant data is grouped together.nnAdvantages of Row Based Tables:n1. ACID Compliance: Row-based storage ensures ACID (Atomicity, Consistency, Isolation, Durability) compliance, making it suitable for transactional workloads.n2. Data Integrity: Row-based tables maintain the original order of data rows, which can be important in some applications that require sequential access to data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
