Difference between revisions of "Template:SQWareProduction sqwmsq StatisticsDatabase.ksh presentation"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by Expdbtools)
 
m (Updated by BatchUser)
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
<br>Update statistic for all tables of the database
+
<br>Update Statistics for all tables of the database
 
<br>Use command: update statistics [$lvsqw_Owner].[$lvsqw_TableName] with fullscan, all
 
<br>Use command: update statistics [$lvsqw_Owner].[$lvsqw_TableName] with fullscan, all

Latest revision as of 20:29, 16 June 2014


Update Statistics for all tables of the database
Use command: update statistics [$lvsqw_Owner].[$lvsqw_TableName] with fullscan, all