>>-CREATE--+----------------------------+--INDEX--index-name----> +-UNIQUE--+----------------+-+ | '-WHERE NOT NULL-' | '-ENCODED VECTOR-------------' .-,---------------------. V .-ASC--. | >--ON--table-name--(----column-name--+------+-+--)--------------> '-DESC-' >--index-options----------------------------------------------->< index-options: |--+-------------------------------------+----------------------> | .-DISTINCT-. | '-WITH--integer--+----------+--VALUES-' .-PAGESIZE--64------. (1) >--+-----------------+--+-------------------+-------------------| +-NOT PARTITIONED-+ '-PAGESIZE--+-8---+-' '-PARTITIONED-----' +-16--+ +-32--+ +-64--+ +-128-+ '-512-'
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.