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

From Wiki_dbSQWare
Jump to navigation Jump to search
Exploit (talk | contribs)
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