InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What is Column store in Db2 BLU Acceleration? |
|
Answer» Db2 column-organized tables ADD columnar CAPABILITIES to DB2 databases, which include data that is stored with column organization and vector processing of column data. If the workload is entirely an analytics or OLAP workload, the recommended approach is to put as many tables as possible into a column-organized format. The process of inserting data into column-organized tables, or updating previously inserted data, is optimized for large INSERT transactions. As a RESULT, workloads that are transactional in nature should not use column-organized tables. Traditional row-organized tables with index access are generally better suited for these types of workloads. With column-organized tables, performance is optimal if 100 or more ROWS are impacted by each insert or update transaction. |
|