Answer Posted / veni botcha
Hey Buddy!!
U r mistaken we can only compress 255 distinct values per
column plus nulls(by default).
Compressed values are stored in table header.
also compression cannot be done on primary index columns
and alter table does not support compression on existing
columns.
Compression works with multi-set tables.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
What is the use of having index on table?
What are the updated features of teradata?
What is the use of stored procedures in teradata?
Explain parsing engine in teradata?
What are the steps to create a data model?
Can you connect multiload from ab initio?
Explain the most common data types used in teradata?
What is a sparse index?
How do you set the session mode parameters in bteq?
What interface is used to connect to windows based applications?
What is teradata?
What is meant by Teradata Gateway?
How do you verify a complicated sql?
What do you mean by caching in teradata?
what is sysdba and sysdbc ? which has high priority ?