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
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.
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.
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.
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
zarko
4 years agopieknyjoe
4 years, 5 months agodb2tester
5 years, 1 month agodb2tester
5 years, 1 month agodb2tester
5 years, 1 month ago