Database

turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

2 weeks ago

2 weeks ago

Hi there,

I am currently developing a stored procedure to attempt to detect and compress the top 10 values in all columns given a database and tablename.

I would like to know when compressing if I set say DECIMAL (9,2) COMPRESS (02.00)

Would that compress the value 2.0? As whilst technically they are the same value I don't know if Teradata will see them as strictly being equal.

Many Thanks

Mark

I am currently developing a stored procedure to attempt to detect and compress the top 10 values in all columns given a database and tablename.

I would like to know when compressing if I set say DECIMAL (9,2) COMPRESS (02.00)

Would that compress the value 2.0? As whilst technically they are the same value I don't know if Teradata will see them as strictly being equal.

Many Thanks

Mark

Solved! Go to Solution.

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

2 weeks ago

1 ACCEPTED SOLUTION

3 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

2 weeks ago

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

2 weeks ago

2 weeks ago

Thanks Dave :)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

2 weeks ago

2 weeks ago

Top 10 is perhaps not the best answer. Top 7 or top 15 might better choices if a fixed number is desired. The reason is that each power of two number of compressed values requires another compression bit in the record. Might as well use the full expressinve power of the bits that are required by the number of values. 10 values leaves 5 unused bit combinations in the 4 bits required.