16.20 - Hash Index and Join Index - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Data Control Language

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1149-162K
To... the user must have the...
create a hash or join index CREATE TABLE privilege on the database in which the hash index or join index is created.
drop a hash index DROP TABLE or INDEX privilege on the indexed base table or its containing database.
drop a join index DROP TABLE or INDEX privilege on each of the covered tables or their containing databases.