Difference between revisions of "Template:SQWareProduction sqwsyb UpdtStatsDatabase.ksh presentation"
m (Updated by Expdbtools) |
m (Updated by BatchUser) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | <br>update index | + | <br>update index Statistics |
| − | <br>use the command 'update index | + | <br>use the command 'update index Statistics $lvsqw_Owner.$lvsqw_Table' |
| − | <br>compute | + | <br>compute Statistics on all indexed columns |
| − | <br>you can also force delete with 'delete | + | <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 20: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'
