Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is use of compress in terdata?Explain?

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


Please Help Members By Posting Answers For Below Questions

Why managing the data is important?

1001


Describe the set operators in teradata.

992


What can be achieved by using the teradata rdbms?

1023


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1762


How is MLOAD Client System restarted after execution?

1123


Comment whether bottleneck is an error or not.

1124


what are the day to day activities of teradata DBA ?

5805


Highlight a few of the advantages that ETL tools have over Teradata.

1073


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3607


If a Node is busy what are the steps you can take to avoid ?

2399


What are the multiload utility limitations?

1039


What do you mean by caching in teradata?

1037


What is the difference between teradata and oracle?

1005


How to Extract data from multiple legacy systems?

1095


What is primary index and secondary index?

1011