db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: Horrible performance - how can I reclaim table space?
Date Thu, 24 Sep 2009 08:00:52 GMT
T K <sanokistoka@yahoo.com> writes:

> BTW, I have to ask this question: how exactly do we define OFFLINE
> compression? I assume I still bring the database up and call the compression
> stored proc from ij, but no one else connects, correct?

When people talk about offline compression, I think they mean the
SYSCS_UTIL.SYSCS_COMPRESS_TABLE routine, as opposed to
SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE. Probably, the use of
online/offline when talking about compression is due to confusion with
the backup terminology.

-- 
Knut Anders

Mime
View raw message