Difference between revisions of "Template:SQWareProduction sqwsyb RebuildDatabase.ksh presentation"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by Expdbtools)
 
m (Updated by BatchUser)
 
Line 3: Line 3:
 
<br>You can choose options:
 
<br>You can choose options:
 
* Size min of table to consider
 
* Size min of table to consider
* Min cluster ratio for table before rebuild it
+
* Min cluster ratio for table before Rebuild it
* Min cluster ratio for index before rebuild it
+
* Min cluster ratio for index before Rebuild it

Latest revision as of 18:47, 5 April 2014


Rebuild index or table who need reorganisation
based on optdiag command to retrieve cluster ratio of tables and indexes
You can choose options:

  • Size min of table to consider
  • Min cluster ratio for table before Rebuild it
  • Min cluster ratio for index before Rebuild it