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

Latest revision as of 15:08, 23 February 2025

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) 0 edits m Updated by Expdbtools		Latest revision as of 15:08, 23 February 2025 view source BatchUser (talk \| contribs) Bots, Bureaucrats 32,902 edits m Updated by BatchUser
(3 intermediate revisions 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