15.00 - DisableSyncScan - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

DisableSyncScan

Purpose  

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 Teradata Database restart.

Usage Notes  

The synchronized full table scan feature of Teradata Database 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 are accessing 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 Topics

See “SyncScanCacheThr” on page 444.