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,
Radovan
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
