db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Katherine Marsden <kmarsdende...@sbcglobal.net>
Subject Re: no records in sys.sysstatistics
Date Fri, 09 Aug 2013 01:19:56 GMT
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


Mime
View raw message