For more information about:
- Hash indexes, see “Effects of Join Indexes.”
- Using CREATE HASH INDEX to create a hash index, see SQL Data Definition Language - Syntax and Examples, B035-1144.
- Using DROP HASH INDEX to drop a hash index, see SQL Data Definition Language - Syntax and Examples, B035-1144.
- Using HELP HASH INDEX to display the data types of the columns defined by a hash index, see SQL Data Definition Language - Syntax and Examples, B035-1144.
- Database design considerations for hash indexes, see Database Design, B035-1094.
Consult the following books for more detailed information on using hash indexes to enhance the performance of your databases:
- Database Design, B035-1094
- SQL Data Definition Language - Syntax and Examples, B035-1144