The correct answer is B.
In DB2® Version 10.5, support is added for NOT ENFORCED primary key and unique constraints. These informational constraints help the query optimizer to select optimal data access plans when index access to the data provides no additional benefit.
If you know that the data conforms to these constraints, you can use the NOT ENFORCED capability to help achieve two goals:
- Improve performance, primarily in insert, update, and delete operations on the table
- Reduce space requirements that are associated with enforcing a primary key or unique constraint
Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.wn.doc/doc/c0061153.html
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.
db2tester
5 years, 6 months ago