db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: How to update cardinality statistics
Date Mon, 17 Oct 2005 18:26:07 GMT
Take a look at Tuning Derby manual page:
http://db.apache.org/derby/docs/10.1/tuning/ctunstats848901.html

This provides several ways to update cardinality information.

Satheesh

Radovan Biciste wrote:

> Hello,
> I'm very new to derby. I was looking how to update cardinality
> statistics. I have joins between tables with couple hundreds of rows
> and about 600 thousands of rows. I'm using embedded server version
> 10.1.1 .0.
> Here is what I've found so far:
> 1. UPDATE STATISTICS FOR TABLE mytable is giving me a syntax error.
> Should work on Cloudscape though.
> 2. SYSCS_UTIL.SYSCS_COMPRESS_TABLE should update statistics but does
> not make too much sense as I do only inserts. It would take tooo much
> time.
>
> Am I missing something ?
> Thank you very much,
> Radovan
>
>
>


Mime
View raw message