What is use of compress in terdata?Explain?

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


Please Help Members By Posting Answers For Below Questions

How to eliminate product joins in a teradata sql query?

804


Differentiate primary key and partition key?

765


Explain the meaning of Amp?

787


What is the syntax for case when statement?

815


Explain fallback in teradata?

804


how do you manage the production space. what are the proactive methods you can take ?

1673


In general, how do you optimze any sql in teradata?

786


Is multi insert ansi standard?

1952


What are the 5 phases in a multiload utility?

811


Describe primary index in teradata. And what are the available primary index types?

752


How do you see a ddl for an existing table?

779


In Teradata, how do we Generate Sequence?

805


What interface is used to connect to windows based applications?

810


What are types of partition primary index (ppi) in teradata?

808


What are default access rights in teradata?

851