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

From Wiki_dbSQWare
Jump to: navigation, search
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 17: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"