17.10 - Example: Using FORCE to Change the Temperature of a Row Partition - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Teradata® Virtual Storage

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1179-171K
Language
English (United States)

The following example sets the temperature for a subset of rows a partitioned table. In this case, the rows are those in the combined partition identified by an external partition number of 9.

Ferret  ==>
> force "test.ppi_t02" 400 9 temperature = hot

FORCE command changed the temperature of table test.ppi_t02
to HOT for the specified partition.
The temperature of 5 cylinders have been changed to HOT.