Disables or enables caching portions of large tables for the purpose of synchronized full table scans. The amount of cache that can be used for synchronized scans is set using the SyncScanCacheThr field.
Field Group
Performance
Valid Settings
| Setting | Description |
|---|---|
| TRUE | Disables synchronized full table scanning of large tables. |
| FALSE | Enables synchronized full table scans. |
Default
FALSE
Changes Take Effect
After the next database restart.
Usage Notes
The synchronized full-table scan feature of Teradata allows several table scanning tasks to simultaneously access the portion of a large table that is currently in the cache. Synchronized table scans happen only when full-table scans access similar areas of a large table. Synchronized table scans can improve database performance by reducing the required disk I/O. Synchronized table scans are available only to large tables undergoing full-table scans.
Related Information
See SyncScanCacheThr.