Template:SQWareProduction sqwsyb UpdtStatsParallelDatabase.ksh presentation

From Wiki_dbSQWare
Revision as of 19:20, 9 April 2022 by BatchUser (talk | contribs) (Updated by BatchUser)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


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'

Retrieved from "https://wiki.dbsqware.com/index.php?title=Template:SQWareProduction_sqwsyb_UpdtStatsParallelDatabase.ksh_presentation&oldid=20521"