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 StanleyBradbury
Date Thu, 09 Sep 2010 18:46:02 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 StanleyBradbury.
http://wiki.apache.org/db-derby/CheckingForIndexStatistics?action=diff&rev1=3&rev2=4

--------------------------------------------------

  T3 (SQL060524012836170)
  }}}
  == Initializing Statistics ==
- '''Version 10.3 - 10.2 '''builds since svn rev. 464683 - '''10.1 '''builds since svn rev.
632065
+ ===  Version 10.3 and higher  plus version 10.2  builds since svn rev. 464683 AND 10.1 builds
since svn rev. 632065 ===
+ Use the Compress Table Utility.  See Derby feature 737 for more information: 
  
- Derby-737: enhanced the Compress Table utility so that it will initialize index statistices
for indexes that it rebuilds.  Use Compress table to establish cardinality statistics for
tables that contain data when running the above listed versions.
+ '''Derby-737''': enhanced the Compress Table utility so that it will initialize index statistices
for indexes that it rebuilds.  Use Compress table to establish cardinality statistics for
tables that contain data when running the above listed versions.
  
- '''Previous versions:'''
+ === Previous versions: ===
  
  For indexes without statistics, assuming that there is now data in the tables, dropping
and recreating the indexes will establish the statistics.  Use the DBLOOK tool to assist with
recreating the indexes and keys.  DBLOOK separates indexes that support a key from non-key
indexes so you can determine the proper DROP syntax to use and also provides the CREATE INDEX
or ALTER TABLE statement needed to re-establish the index.
  

Mime
View raw message