Goal | Privileges User Needs |
---|---|
Collect or drop statistics on a permanent or global temporary table, a hash index, or a join index | STATISTICS privilege on the table, global temporary table, hash index or join index. |
Collect or drop statistics on a permanent row level security table | STATISTICS and OVERRIDE SELECT privileges on the table. |
Collect or drop statistics on a volatile table or a materialized global temporary table | None required. |
Use HELP STATISTICS to display summary or detail information for collected statistics for the specified data table or hash or join index |
|
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:
If the values option is specified:
|