15.00 - Chapter 18 File System Information Macros - Teradata Database

Teradata Database SQL Functions, Operators, Expressions, and Predicates

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

These macros allow you 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.

The information is similar to that displayed by the SHOWBLOCKS command of the Ferret utility. Because the information from these macros 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 Utilities: Volume 1 (A-K).