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
Why managing the data is important?
Describe the set operators in teradata.
What can be achieved by using the teradata rdbms?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
How is MLOAD Client System restarted after execution?
Comment whether bottleneck is an error or not.
what are the day to day activities of teradata DBA ?
Highlight a few of the advantages that ETL tools have over Teradata.
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
If a Node is busy what are the steps you can take to avoid ?
What are the multiload utility limitations?
What do you mean by caching in teradata?
What is the difference between teradata and oracle?
How to Extract data from multiple legacy systems?
What is primary index and secondary index?