版次注意事項


|8.2 Chapter 4. Environmental Considerations

|Following the section titled "Using the Index Advisor", add the following |section:

|8.2.1 Using Larger Index Keys

| |

|It is possible to allow columns with a length greater than 255 bytes to |be specified as part of an index key. The DB2_INDEX_2BYTEVARLEN registry variable |allows for the use of 2 bytes instead of 1 to store the length of an index |key.

|There are several SQL statements affected by changes to the registry variable. |They are: |

|To convert existing indexes to use larger index keys: drop the indexes, |set the DB2_INDEX_2BYTEVARLEN registry variable to ON, and then recreate the |indexes (using the larger columns).

|For more information on the SQL statements, including syntax descriptions, |refer to the SQL Reference.


[ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]