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
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
<br>update index statistics
<br>update index Statistics
<br>use the command 'update index statistics $lvsqw_Owner.$lvsqw_Table'
<br>use the command 'update index Statistics $lvsqw_Owner.$lvsqw_Table'
<br>compute statistics on all indexed columns
<br>compute Statistics 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 Statistics $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'

Latest revision as of 21:30, 16 June 2014


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