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

What is the primary index in teradata?

1109


What is multi insert?

983


What is the difference between fastload and multiload?

1285


How many codd's rules are satisfied by teradata database?

1043


What do you mean by ttu in teradata?

970


What is a node in teradata?

932


What are the design features involved in teradata?

973


Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1015


What do you mean by caching in teradata?

993


Define views in teradata with syntax.

1021


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

1030


What is the basic syntax for teradata select statement?

980


Did you write stored procedures in teradata?

1055


Difference between stored procedure and macro?

1108


What is the use of stored procedures in teradata?

939