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

From Wiki_dbSQWare
Jump to navigation Jump to search
Exploit (talk | contribs)
m Updated by Expdbtools
 
m Updated by BatchUser
Line 1: Line 1:
<br>Update statistic for all tables of the database
<br>Update Statisticsistic for all tables of the database
<br>Use command: update statistics [$lvsqw_Owner].[$lvsqw_TableName] with fullscan, all
<br>Use command: update Statisticsistics [$lvsqw_Owner].[$lvsqw_TableName] with fullscan, all

Revision as of 18:46, 5 April 2014


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