For more information about:
- Hash indexes, see Effects of Hash Indexes.
- Using CREATE HASH INDEX to create a hash index, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
- Using DROP HASH INDEX to drop a hash index, see Teradata Vantage™ - 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 Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
- Database design considerations for hash indexes, see Teradata Vantage™ - Database Design, B035-1094.
Consult the following documents for more detailed information on using hash indexes to enhance the performance of your databases:
- Teradata Vantage™ - Database Design, B035-1094
- Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144