Statistics | Privileges Needed for Database Administration | Teradata Vantage - Statistics - Analytics Database - Teradata Vantage

SQL Data Control Language
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
sgu1628111251052.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dvv1472243528022
lifecycle
latest
Product Category
Teradata Vantage™
To... the user must have...
collect or drop statistics on a permanent or global temporary table, a hash index, or a join index the STATISTICS privilege on the table, global temporary table, hash index or join index.
collect or drop statistics on a permanent row level security table the STATISTICS and OVERRIDE SELECT privileges on the table.
collect or drop statistics on a volatile table or a materialized global temporary table No privileges required.
use HELP STATISTICS to display summary or detail information for collected statistics for the specified data table or hash or join index
  • Any privilege on the table_name, join_index_name, or hash_index_name
  • Ownership of the table_name or join_index_name
use SHOW STATISTICS to display summary or detail information for collected statistics for the specified data table or hash or join index if the values option is not specified:
  • Any privilege on the table_name, join_index_name, or hash_index_name
  • Ownership of the table_name or join_index_name
if the values option is specified:
  • SELECT on the object being reported