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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
 
Line 1: Line 1:
<br>Update Statisticsistic for all tables of the database
+
<br>Update Statistics for all tables of the database
<br>Use command: update Statisticsistics [$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