On 8/8/2013 3:13 PM, Jasmeet Bhatia (jasmbhat) wrote:
I have in-memory 10.7.1.1 derby.
I am trying to verify if indexes are being used in my query. But I
notice that there are no statistics in the sys statistics table. Any
ideas what is going on?
Jasmeet Bhatia
With 10.8 statistics update is automatic.
With 10.7 you can create/update statistics with the
SYSCS_UTIL.SYSCS_UPDATE_STATISTICS system procedure:
http://db.apache.org/derby/docs/10.7/ref/rrefupdatestatsproc.html
or by compressing the tables:
http://db.apache.org/derby/docs/10.7/ref/rrefaltertablecompress.html
Thanks
Kathey
