【O】ORACLE下更新成本计算相关表的统计信息
金蝶云社区-springwind_liu
springwind_liu
0人赞赏了该文章 801次浏览 未经作者许可,禁止转载编辑于2014年09月08日 11:03:14

--更新统计信息
ANALYZE TABLE T_HS_INIVBALANCEEXPENTRY COMPUTE STATISTICS;
ANALYZE TABLE T_HS_INIVBALANCEENTRY COMPUTE STATISTICS;
ANALYZE TABLE T_HS_INIVBALANCEEXP COMPUTE STATISTICS;
ANALYZE TABLE T_HS_INIVBALANCE COMPUTE STATISTICS;
ANALYZE TABLE T_HS_EXPENSES COMPUTE STATISTICS;
ANALYZE TABLE T_HS_BALANCEEXPENTRY COMPUTE STATISTICS;
ANALYZE TABLE T_HS_BALANCEENTRY COMPUTE STATISTICS;
ANALYZE TABLE T_HS_BALANCEEXP COMPUTE STATISTICS;
ANALYZE TABLE T_HS_BALANCE COMPUTE STATISTICS;
ANALYZE TABLE T_HS_OUTINSTOCKSEQ COMPUTE STATISTICS;
ANALYZE TABLE T_HS_ACCTGPROCESS COMPUTE STATISTICS;
ANALYZE TABLE T_HS_EXPENSESPROCESS COMPUTE STATISTICS;
ANALYZE TABLE T_HS_ACCTGPROCESSENTRY COMPUTE STATISTICS;
ANALYZE TABLE T_HS_INIVBALANCEEXPENTRY_H COMPUTE STATISTICS;
ANALYZE TABLE T_HS_INIVBALANCEENTRY_H COMPUTE STATISTICS;
ANALYZE TABLE T_HS_INIVBALANCEEXP_H COMPUTE STATISTICS;
ANALYZE TABLE T_HS_INIVBALANCE_H COMPUTE STATISTICS;
ANALYZE TABLE T_HS_EXPENSES_H COMPUTE STATISTICS;
ANALYZE TABLE T_HS_BALANCEEXPENTRY_H COMPUTE STATISTICS;
ANALYZE TABLE T_HS_BALANCEENTRY_H COMPUTE STATISTICS;
ANALYZE TABLE T_HS_BALANCEEXP_H COMPUTE STATISTICS;
ANALYZE TABLE T_HS_BALANCE_H COMPUTE STATISTICS;
ANALYZE TABLE T_HS_OUTINSTOCKSEQ_H COMPUTE STATISTICS;
ANALYZE TABLE T_HS_ACCTGPROCESS_H COMPUTE STATISTICS;
ANALYZE TABLE T_HS_EXPENSESPROCESS_H COMPUTE STATISTICS;
ANALYZE TABLE T_HS_ACCTGPROCESSENTRY_H COMPUTE STATISTICS;

ANALYZE TABLE T_CB_PROORDERDIME COMPUTE STATISTICS;
ANALYZE TABLE T_CB_EXPALLOPROCESSREC COMPUTE STATISTICS;
ANALYZE TABLE T_CB_EXPALLOPROCESSSEND COMPUTE STATISTICS;
ANALYZE TABLE T_CB_EXPALLORESULTREC COMPUTE STATISTICS;
ANALYZE TABLE T_CB_EXPALLORESULTSEND COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTALLOPROREC COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTALLOPRORECEXP COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTALLOPROSEND COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTALLOPROSENDEXP COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTALLORESULTREC COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTALLORESULTRECEXP COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTALLORESULTSEND COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTALLORESULTSENDEXP COMPUTE STATISTICS;
ANALYZE TABLE T_CB_PROORDERINFO COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTCALEXPENSE COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTCALEXPENSEDETAIL COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTMATTERIAL COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTMATTERIALDETAIL COMPUTE STATISTICS;
ANALYZE TABLE T_CB_EXPALLOPROCESSREC_H COMPUTE STATISTICS;
ANALYZE TABLE T_CB_EXPALLOPROCESSSEND_H COMPUTE STATISTICS;
ANALYZE TABLE T_CB_EXPALLORESULTREC_H COMPUTE STATISTICS;
ANALYZE TABLE T_CB_EXPALLORESULTSEND_H COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTALLOPROREC_H COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTALLOPRORECEXP_H COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTALLOPROSEND_H COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTALLOPROSENDEXP_H COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTALLORESULTREC_H COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTALLORESULTRECEXP_H COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTALLORESULTSEND_H COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTALLORESULTSENDEXP_H COMPUTE STATISTICS;
ANALYZE TABLE T_CB_PROORDERINFO_H COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTCALEXPENSE_H COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTCALEXPENSEDETAIL_H COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTMATTERIAL_H COMPUTE STATISTICS;
ANALYZE TABLE T_CB_COSTMATTERIALDETAIL_H COMPUTE STATISTICS;

您的鼓励与嘉奖将成为创作者们前进的动力,如果觉得本文还不错,可以给予作者创作打赏哦!

请选择打赏金币数 *

10金币20金币30金币40金币50金币60金币
可用金币: 0