db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "CheckingForIndexStatistics" by BrettBergquist
Date Fri, 30 Mar 2012 17:52:35 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The "CheckingForIndexStatistics" page has been changed by BrettBergquist:
http://wiki.apache.org/db-derby/CheckingForIndexStatistics?action=diff&rev1=4&rev2=5

Comment:
With Derby 10.8.1.2 and beyond, the comparison of "c.isIndex = 1" fails.  See Note for DERBY-4965

  from sys.systables t, sys.sysconglomerates c
      LEFT OUTER JOIN sys.sysstatistics s ON c.conglomerateid = s.referenceid
  where t.tableid = c.tableid
- and c.isindex = 1 and t.tabletype = 'T'  ;
+ and c.isindex = true and t.tabletype = 'T'  ;
  Table (Index)
          |2
  ----------------------------------------------

Mime
View raw message