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

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

Revision as of 00:13, 15 December 2010 (view source) Exploit (talk \| contribs) m (Updated by Expdbtools)		Latest revision as of 20:29, 16 June 2014 (view source) BatchUser (talk \| contribs) 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