Template:SQWareProduction sqwsyb UpdtStatsDatabase.ksh presentation

From Wiki_dbSQWare
Jump to: navigation, search


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'