CREATE HASH INDEX [ database_name. | user_name. ] hash_index_name [, index ] ( column_name_1 [,...]) ON table_name [ BY ( column_name_2 [,...]) ] [ ORDER BY { VALUES [ ( column_name_3 [,...] ) ] | HASH ( column_name_3 [,...] ) | ( column_name_3 [,...] ) } ] [;]
- index
{ MAP map_name [ COLOCATE USING colocation_name ] | [NO] FALLBACK [PROTECTION] | CHECKSUM = { ON | DEFAULT | OFF } | BLOCKCOMPRESSION = { AUTOTEMP | DEFAULT | MANUAL | NEVER } } [,...]