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 primary index in teradata?
What is multi insert?
What is the difference between fastload and multiload?
How many codd's rules are satisfied by teradata database?
What do you mean by ttu in teradata?
What is a node in teradata?
What are the design features involved in teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What do you mean by caching in teradata?
Define views in teradata with syntax.
Highlight a few of the advantages that ETL tools have over Teradata.
What is the basic syntax for teradata select statement?
Did you write stored procedures in teradata?
Difference between stored procedure and macro?
What is the use of stored procedures in teradata?