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

From Wiki_dbSQWare
Jump to navigation Jump to search
Newer edit →
Exploit (talk | contribs)
0 edits
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'

Retrieved from "https://wiki.dbsqware.com/index.php?title=Template:SQWareProduction_sqwsyb_UpdtStatsDatabase.ksh_presentation&oldid=4585"