达梦数据库表信息收集、索引重建

 --表信息收集：
 
 select
         ' CALL SP_TAB_STAT_INIT(''V45_DMXNCS'','''
         || TABLE_NAME
         || ''' );' TABLE_NAME11
 from
         DBA_tables
 where
         owner = 'CPDB'
     and TABLE_NAME like 'T_%' ;
 
 
 
 
 --重建索引：
 
 select
         'ALTER INDEX V45_DMXNCS.'
         || INDEX_NAME
         || '  REBUILD ; ' as "llll"
 from
         DBA_INDEXES
 where
         owner = 'V45_DMXNCS'
     and TABLE_NAME like 'T_%' ;