Teradata VS hybrid storage support is available with Teradata Database Enterprise Tier licensing. For more information, contact your Teradata sales representative.
Temperature-based block-level data compression (TBBLC) and temperature-based data migration between fast and slow storage media is available to all Teradata Database customers, regardless of licensing tier. For more information about TBBLC, see Teradata Vantage™ - Database Design, B035-1094 and Teradata Vantage™ - Database Utilities , B035-1102 .
Initial Data Temperature
When data is loaded into a new table, the system does not know whether that data will be hot (accessed frequently) or cold (accessed infrequently), so it is initially assigned the temperature specified by the appropriate Storage setting in DBS Control. Typically, you can allow the system to set the temperature according to this setting.
Over time, Teradata VS monitors data access patterns, assigns table data a temperature based on those access patterns, and moves data between faster and slower storage to place the hotter data on faster physical storage.
For tables with very specific data access requirements, you can use the TVSTemperature query band (at load time) or the Ferret FORCE command (soon after a table is created) to expedite the time required to place the data into the proper storage grade.
Teradata VS monitors frequency of data access and adjusts data temperatures dynamically as it monitors frequency of data access. Consequently, temperatures can change from those specified using the TVSTemperature query band or the FORCE command, if the measured frequency of actual data access differs from the temperature that is initially set.