Template:SQWareProduction sqwsyb UpdtStatsParallelDatabase.ksh presentation: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
(No difference)
|
Latest revision as of 20:20, 9 April 2022
update index Statistics in parallel
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'