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/07/07 18:59:21 UTC

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

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 jeanTanderson:
http://wiki.apache.org/db-derby/HintsAndTips

------------------------------------------------------------------------------
  
  || Title || Description || Submitted by (optional) ||
  || ListTableNames || Data dictionary query to return table names and schemas ||  ||
+ || ListTableColumns || How to list information about the columns in a table || ||
  || 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) || ||