Wiki / 存储参数

Controls usage of the B-tree deduplication technique described in Section 65.1.4.3 . Set to ON or OFF to enable or disable the optimization. (Alternative spellings of ON and OFF are allowed as described in Section 19.1 .) The default is ON . Turning deduplicate_items off via ALTER INDEX prevents future insertions from triggering deduplication, but does not in itself make existing posting list tuples use the standard tuple representation.

此版本暂无所选语言的定义，以下显示原始英文内容。

Applies to

B-tree indexes

Value type

boolean

Default

ON

signature

WITH (deduplicate_items = value)