Which of the following is TRUE about indexes on column organized tables?
Which of the following is TRUE about indexes on column organized tables?
Indexes are automatically created to enforce unique constraints on column-organized tables to ensure data integrity. This is particularly important for primary keys and unique constraints which require the data to be unique across the table.
Error in my previous comment, the answer "C. Indexes are automatically created to enforce unique constraints" seems the best answer, if you create a primary key on your column-organized table.
DB2 Blu is a memory technology. You do not need index for the column-organized table. The synopsis is a meta-table automatically created and maintained by the system to store metadata for an associated user-defined column-organized table. The synopsis table stores the minimum and maximum values for each column across a range of rows and does not use index.
Indexes can be explicitly created on column-organized tables, with a few restrictions: from: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0061528.html
C is good C. Indexes are automatically created to enforce unique constraints
The answer A is not correct because you can create index and primary key. None of the answers seems correct ! Eventually, the answer B is the best answer.