PrepAway - Latest Free Exam Questions & Answers

Which registry variable should be used to specify that …

Which registry variable should be used to specify that 20 percent of each index page is to be left as as free
space when building any index in any database?

PrepAway - Latest Free Exam Questions & Answers

A.
DB2_INDEX_DEFAULT

B.
DB2_EXTENDED_OPTIMIZATION

C.
DB2_INDEX_PCTFREE_DEFAULT

D.
DB2_ENABLE_AUTOCONFIG_DEFAULT

One Comment on “Which registry variable should be used to specify that …

  1. Chow, Kenneth KY says:

    This registry variable specifies what percentage of each index page to leave as free space when building the index. The setting for DB2_INDEX_PCTFREE_DEFAULT is overridden if you explicitly specify the PCTFREE clause on the CREATE INDEX statement. The registry variable does not affect the LEVEL2 PCTFREE clause on the CREATE INDEX statement.




    0



    0

Leave a Reply