What is use of compress in terdata?Explain?

Answer Posted / tdguy

Highly common values are used for compression. More space
can be saved. The value is stored in table header.
Datatypes like INTERVAL, TIME, TIMESTAMP, VARBYTE and
VARCHAR cannot be compressed.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of teradata?

811


What is the purpose of upsert command?

829


Explain the term 'columns' related to relational database management system?

784


What do you mean by ttu in teradata?

760


Highlight the points of differences between the database and user in Teradata.

827


What are the primary characteristics of the Teradata.

823


How do you see a ddl for an existing table?

783


What is the use of having index on table?

761


Explain the term 'primary key' related to relational database management system?

833


What is meant by a node?

824


Why does varchar occupy 2 extra bytes?

858


What is the primary index in teradata?

826


List the logical and conditional operators that are used with teradata along with their meanings?

768


Give a justifiable reason why Multi-load supports NUSI instead of USI.

913


How will you solve the problem that occurs during update?

816