Answer Posted / 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 |
Post New Answer View All Answers
How to eliminate product joins in a teradata sql query?
Differentiate primary key and partition key?
Explain the meaning of Amp?
What is the syntax for case when statement?
Explain fallback in teradata?
how do you manage the production space. what are the proactive methods you can take ?
In general, how do you optimze any sql in teradata?
Is multi insert ansi standard?
What are the 5 phases in a multiload utility?
Describe primary index in teradata. And what are the available primary index types?
How do you see a ddl for an existing table?
In Teradata, how do we Generate Sequence?
What interface is used to connect to windows based applications?
What are types of partition primary index (ppi) in teradata?
What are default access rights in teradata?