15.10 - File System: Synchronized Full Table Scans Columns - Teradata Database

Teradata Database Resource Usage Macros and Tables

Product
Teradata Database
Release Number
15.10
Published
April 2016
Language
English (United States)
Last Update
2018-05-17
dita:mapPath
Resource_Usage_Macros_15_10.ditamap
dita:ditavalPath
ft:empty

These columns contain statistics relating to synchronized full table scans.

The following columns are moved from the ResUsageIvpr table to the ResUsageSvpr table to avoid costly joins.
Column Name Mode Description Data Type
FileSyncGroups track Number of groups of scanners involved in full table scans. A group consists of scanners who are able to use the same read I/O to obtain data from disk. FLOAT
FileSyncScanners track Number of tasks involved in full table scans who are willing to synchronize with other scanners. FLOAT
FileSyncScans count Number of attempts to synchronize a full table scan. FLOAT
FileSyncSubtables track Number of subtables scanned by one or more full table scanners who are willing to synchronize scans. FLOAT