File System Columns | ResUsageSvpr Table | Teradata Vantage - File System: Synchronized Full Table Scans Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
fwg1557098454552.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢

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