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
Explain teradata architecture in detail with a diagram.
Difference between inner join and outer join?
What is the purpose of upsert command?
Explain the most common data types used in teradata?
What are the string manipulation operators and functions associated with teradata?
How to Extract data from multiple legacy systems?
How to eliminate product joins in a teradata sql query?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
How many sessions of MAX is PE capable of handling at a particular time?
What are the uses of client software involved in teradata?
Which is more efficient group by or distinct to find duplicates?
What are differences between teradata and ansi session modes in teradata?
Explain teradata vs. Redshift?
What is a level of granularity of a fact table?
How many tables can you join in v2r5?