Interested to Buy Any Domain ? << Click Here >> for more details...
What is use of compress in terdata?Explain?
- 11 Answers
- 35991 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / oceanblue
Part of the answer by Sat!sh is correct.
However, we can store only one value per column and not 3
(air, sea, road). The compressed value is stored in column
header and is to be used as default of that column unless a
value is present.
e.g.
Dept of Taxes in Washington has a database that tracks all
people working in Washington. Around 99.9% of the tax payers
would have Washington as their state code on their address.
Instead of storing “Washington” in millions of records the
compress will store the value “Washington” in the table
header. Now, a value can be assumed in a row as a default
unless another value exists inside the column.
| Is This Answer Correct ? | 5 Yes | 14 No |
What is the difference between global temporary tables and volatile temporary tables?
What are the updated features of teradata?
How to run a query in teradata?
Why teradata is used?
What are the joins in teradata and how many types of joins are there in teradata?
one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?
What is the difference between teradata and oracle?
What is oltp?
What are the things to be considered while creating secondary index?
What are the various reporting tools in the market?
What are the components provided on node?
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
Teradata 
