17.10 - Example: Hash Index With Checksum - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)
The following hash index is created with disk I/O checksum ON:
     CREATE HASH INDEX line_hidx_6, CHECKSUM=ON 
       (l.shipdate) ON lineitem
     BY (l_shipdate)
     ORDER BY VALUES;
This creates an index that is equivalent in structure to the following join index:
     CREATE JOIN INDEX line_jidx_6, CHECKSUM=ON AS
      SELECT (l_orderkey), (l_shipdate, lineitem.ROWID) 
      FROM lineitem
      ORDER BY l_orderkey
     PRIMARY INDEX (l_shipdate);