Question - Explain the BLOCK COMPRESSION?
Answer -
Use this option to set the temperature-based block compression state of a table.
Teradata Virtual Storage tracks data temperatures at the level of cylinders, not tables, and the file system obtains its temperature information from Teradata Virtual Storage, so it also handles temperature-related compression at cylinder level.