db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Karp <dk...@zimbra.com>
Subject SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE and reindexing
Date Tue, 06 Nov 2007 20:24:09 GMT
I think we may be getting hit with DERBY-269 (stale index cardinality causes table scans).
 The command listed in that JIRA ("alter table <table-name> compress [sequential]")
isn't valid.  Calling SYSCS_UTIL.SYSCS_COMPRESS_TABLE works, but takes a huge amount of CPU,
disk I/O, and disk space.  Is there a simpler, straightforward way to force recalculation
of these indexes?

https://issues.apache.org/jira/browse/DERBY-269

Mime
View raw message