db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Radovan Biciste <rbici...@softhome.net>
Subject Re: How to update cardinality statistics
Date Mon, 17 Oct 2005 18:54:57 GMT
Hello Satheesh,
I'm not sure why I missed that part of documentation, sorry.
I've checked SYS.SYSSTATISTICS and it is empty.
In the documentation there is also note "If statistics are turned off 
system wide".
Is there any way how to check that my statistics are up to date or at 
least existing ? I'm running embedded server.
Thank you,

Satheesh Bandaram wrote:
> 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

View raw message