收集统计信息迁移

COLLECT STAT tab1 COLUMN (c1, c2);	

ANALYZE tab1 (c1, c2);

COLLECT STATISTICS
  COLUMN (customer_id,customer_name) 
, COLUMN (postal_code) 
, COLUMN (customer_address) 
ON customer_t;

ANALYZE customer_t (
     customer_id
     ,customer_name
     ,postal_code
     ,customer_address
)
;

COLLECT STATISTICS
  COLUMN (
  Order_Date
  -- ,o_orderID
/*COLLECT 
STATISTICS*/
  ,Order_ID
     )  
ON order_t;

ANALYZE order_t (
    Order_Date
     ,Order_ID
)
;

COLLECT STATS COLUMN (
     empno
     ,ename
)
     ON ${schemaname}."usrTab1"
;

ANALYZE ${schemaname}."usrTab1" 
(
     empno
     ,ename
)
;