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

Revision as of 21: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 18:46, 5 April 2014 view source BatchUser (talk \| contribs) Bots, Bureaucrats 31,047 edits m Updated by BatchUser ← Older edit		Revision as of 21:29, 16 June 2014 view source BatchUser (talk \| contribs) Bots, Bureaucrats 31,047 edits m Updated by BatchUser Newer edit →
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