查看统计信息:
select t.LAST_ANALYZED,T.NUM_ROWS,t.* from user_tables t where table_name in
('VW_AR_LSWLDW','COMPANYPARTNERS','LSBZDW','LSWLDW','BANKS','BANKACCOUNTS')
analyze table COMPANYPARTNERS compute statistics;
查看统计信息:
select t.LAST_ANALYZED,T.NUM_ROWS,t.* from user_tables t where table_name in
('VW_AR_LSWLDW','COMPANYPARTNERS','LSBZDW','LSWLDW','BANKS','BANKACCOUNTS')
analyze table COMPANYPARTNERS compute statistics;