Interested to Buy Any Domain ? << Click Here >> for more details...
What is use of compress in terdata?Explain?
- 11 Answers
- 36379 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sat!sh
Compression is used to Minimize the table size, for example
when the table size is increasing anonymously We can use
Compression to reduce the size of the table
Conditions:
1.Compression can be declared at the time of table creation
2.We can compress up to 256 column values(not columns)
3.We can't compress variable length fields
(vartext,varchar..)
Explanation for 2 condition:
create table tab1
(
:
:
Order_type char(25) compress ('air','sea','road')
:
)
in the above example order type have 3 fields, one should
be selected by the user, so one of the field will repeat
for every order, like these column values we can use
compress statement because these are repeating for entire
table, like these column values TD supports 256 col
generally NCR people will provides ready made scripts for
these type of compressions
----
Hi friends got any best ans share with us :)
| Is This Answer Correct ? | 18 Yes | 3 No |
Answer / 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 |
Answer / yuvaevergreen
Use of compress is multivalue compression saves space and
adds speed.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / ismail
Both of ur answers about the number of columns values that
can be compressed (255 distinct values/single value) are
correct. Versions upto V2R4 allows only single value
compression. Since V2R5 multi-value compression is possible.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / vinay
@Veni ...FYI Compression works with SET tables as well.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / yuvaevergreen
Compression helps in enhanced storage, improved response
time, CPU savings.
Select Currentperm from DBC.tablesize where
tablename='tablename'; Using the permsize, we can know about
the percentage space saved.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / surendra
Now, 13.10 is equiped with 510 characters wide compression
including more datatypes. The ALC which helps to use the UDF
is adding more power to compression. I feel happy that the
MVC and ALC can work together which also reduce the further
effort while working on a compressed data column.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rahul
I heart about in Teradata 14 ,NCR allows compress on varchar columns as well ,upto 510 character please correct me if i m wrong.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the available primary index types?
Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?
What is the difference between union and union all in teradata?
any one pls tell me what are the table names in banking project?
In the Primary Index, what is the score of AMPs that are actively involved?
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
Why Fload doesn’t support multiset table?
Can you connect multiload from ab initio?
How to find duplicates in a table?
In Teradata, how do we Generate Sequence?
When tpump is used instead of multiload?
Which Teradata concept allows more than one model generation?
Teradata 
