有两个ORACLE数据库，A跟B，分别有一张表A1和B1,两张表字段都一样。我用 select column_name from user_tab_columns where table_name='A1' select column_name from user_tab_columns where table_name='B1'
select column_name from dba_tab_columns where owner='A' and table_name='A1'; select column_name from dba_tab_columns where owner='B' and table_name='B1'; select column_name from user_tab_columns where table_name='A1' order by column_name;再比对 select column_name from user_tab_columns where table_name='B1' order by column_name;再比对
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 上面一个简单的SQL,执行时间2.6� ......
