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
