All Forums Database
Random_Thought 87 posts Joined 06/09
22 Jul 2009
another Compression Question

As a query runs and returns rows from a compressed table into spool, are the columns compressed in the spool space?

Fred 1096 posts Joined 08/04
22 Jul 2009

In current releases of Teradata, as long as compressed columns are simply copied into the spool then they remain compressed.

Random_Thought 87 posts Joined 06/09
23 Jul 2009

Ok, so CPU resource is used to return decompressed rows back to the client? If so where is this CPU usage logged? (The record has been logged in DBQL by this point)

Can any of the Teradata people confirm this?

smazingo 3 posts Joined 04/09
27 Jul 2009

this cpu would show up as normal part of amp processing in the DBQL.

You must sign in to leave a comment.