Template:SQWareProduction sqwsyb UpdtStatsDatabase.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 1: Line 1:
<br>update index statistics
<br>update index Statisticsistics
<br>use the command 'update index statistics $lvsqw_Owner.$lvsqw_Table'
<br>use the command 'update index Statisticsistics $lvsqw_Owner.$lvsqw_Table'
<br>compute statistics on all indexed columns
<br>compute Statisticsistics on all indexed columns
<br>you can also force delete with 'delete statistics $lvsqw_Owner.$lvsqw_Table'
<br>you can also force delete with 'delete Statisticsistics $lvsqw_Owner.$lvsqw_Table'
<br>dynamically calculates a sample to put option 'with sampling=$lvsqw_SamplePct percent'
<br>dynamically calculates a sample to put option 'with sampling=$lvsqw_SamplePct percent'

Revision as of 18:47, 5 April 2014


update index Statisticsistics
use the command 'update index Statisticsistics $lvsqw_Owner.$lvsqw_Table'
compute Statisticsistics on all indexed columns
you can also force delete with 'delete Statisticsistics $lvsqw_Owner.$lvsqw_Table'
dynamically calculates a sample to put option 'with sampling=$lvsqw_SamplePct percent'