Template:SQWareProduction sqwsyb UpdtStatsDatabase.ksh presentation: Difference between revisions
Jump to navigation
Jump to search
m Updated by Expdbtools |
(No difference)
|
Revision as of 01:14, 15 December 2010
update index statistics
use the command 'update index statistics $lvsqw_Owner.$lvsqw_Table'
compute statistics on all indexed columns
you can also force delete with 'delete statistics $lvsqw_Owner.$lvsqw_Table'
dynamically calculates a sample to put option 'with sampling=$lvsqw_SamplePct percent'