Template:SQWareProduction sqwsyb UpdtStatsDatabase.ksh presentation: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
m Updated by BatchUser |
||
| 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 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'