You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-commits@db.apache.org by Apache Wiki <wi...@apache.org> on 2006/08/14 15:51:36 UTC

[Db-derby Wiki] Update of "HintsAndTips" by StanleyBradbury

Dear Wiki user,

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

The following page has been changed by StanleyBradbury:
http://wiki.apache.org/db-derby/HintsAndTips

------------------------------------------------------------------------------
  || ListKeyIndexes  || Data dictionary query to list the index names support Primary and Foreign Keys || ||
  || DatabaseConsistencyCheck || Running SYSCS_UTIL.SYSCS_CHECK_TABLE on all tables in a database ||  ||
  || CheckingForIndexStatistics || Got Cardinality Statistics for your indexes? (and how to get them) || ||
+ || UniqueIdentityAndInserts || Tips on inserting manually assigning values into identity columns used in unique keys  ||  ||
+ || DebugPropertiesTmpl || Annotated {{{derby.properties}}} useful for development and test environments  ||  ||
+ || LogStamentTextMsgs || Reading {{{logStatementText}}} messages to find the compile and execution times of a statement||  ||