db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Radovan Biciste <rbici...@softhome.net>
Subject How to update cardinality statistics
Date Mon, 17 Oct 2005 18:15:05 GMT
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,

View raw message