another Compression Question

Database

another Compression Question

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

Re: another Compression Question

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

Re: another Compression Question

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?
Teradata Employee

Re: another Compression Question

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