File System Columns | ResUsageSvpr Table | Teradata Vantage - File System: Synchronized Full Table Scans Columns - Analytics Database - Teradata Vantage

Resource Usage Macros and Tables

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
efj1628112349534.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
wqp1472240716284
lifecycle
latest
Product Category
Teradata Vantageā„¢

These columns contain statistics relating to synchronized full table scans.

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