17.10 - File System Information Macros and Functions - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

These macros and functions allow you to use various Ferret SHOW commands to display Teradata 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.

For more information on Ferret, see Teradata Vantage™ - Database Utilities, B035-1102.