16.20 - Overview - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Advanced SQL Engine
Teradata Database
Release Number
April 2020
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

These macros and functions allow you to use various Ferret SHOW commands to display Teradata Database File System statistics about data block size, number of rows per data block, and information about the compression status of data blocks for specified tables or groups of tables. You can also run frequency of access reports for database objects on a specific AMP.

The information is similar to that displayed by the SHOWBLOCKS, SHOWCOMPRESS, and SHOWWHERE commands of the Ferret utility. Because the information from these macros and functions is created in regular database tables, it can be easier to share and process the information. Permissions to create and view this information are also easier to manage using standard SQL GRANT and REVOKE privilege statements.