Archives of the TeradataForum

Message Posted: Wed, 28 Aug 2002 @ 04:11:44 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Question on compression

From:		Sanchet Surendra Dighe

-----Original Message-----
From: Matthew Winter
Sent: Wednesday, August 28, 2002 2:06 AM
To: TDATA-L
Subject: Re: Question on compression

--------

One thing that disappointed me about the compression was the way the system automatically decompresses any compressed fields when they are brought into the Spool area. This to me seems to be unecessary and very costly. Shawly in most queries the field would only need to be decompressed when it is ready for sending back the data to the requestor.

Hi Matthew,

I don't understand why you say that the decompression in the spool is unnecessary. Can you elaborate on it a bit, please?

By my understanding, the rows in the spool either constitute the result-set of the query, or, are needed for intermediate operations like joins, merges, sorts, etc. In both cases, it facilitates the operations on the spool data provided the rows are present in their uncompressed form.

Regards,

Sanchet