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