Knut, thank you, updating the statistics helped very much! (I added a tunable stats updater for different servers to my software)
Fyodor -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Tuesday, April 06, 2010 1:30 PM To: [email protected] Subject: Re: Derby internally converts char for bit data to hex string /// This section in the tuning guide lists when the index cardinality statistics are automatically updated: http://db.apache.org/derby/docs/10.5/tuning/ctunstats57373.html Additionally, there is a system procedure that can be used to update the statistics manually: http://db.apache.org/derby/docs/10.5/ref/rrefupdatestatsproc.html
