Hash/Join Index | Privileges for Database Administration | Teradata Vantage - 17.05 - Hash Index and Join Index - Teradata Database

Teradata Vantageā„¢ - SQL Data Control Language

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1149-170K
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.