-
编辑 删除
NC 补丁源码编译
E:\nccode\nc56\modules\gl>d:\sun\sdk\jdk\bin\javac -verbose -classpath E:\nccode\nc56\modules\gl\lib\pubgl.jar;E:\nccode\nc56\external\lib\basic.jar nc\bs\gl\pubinterface\IVoucherSign.java[解析开始时...
-
编辑 删除
测试达梦优化器对子查询unnest的支持
create table test1 as select * from sysindexescreate table test2 as select * from systablescreate index i_test1_1 on test1 (tableid)create index i_test1_2 on test1 (name)create index i_test2_1 on t...
-
编辑 删除
达梦对于outer join 的优化 及其不足
达梦数据库对outer join做了优化处理：SQL>explain select * from test_obj1 a left join test_obj2 s2 on a.object_id=S.object_id3 where s.object_name in ('N','TEST1');explain selec...
-
编辑 删除
测试 达梦 complex_view_merging
select object_id from test_obj1 a left join(select sum(DATA_OBJECT_ID) sm,b.object_id from test_obj1 b group by b.object_id) c on a.object_id=c.object_idwhere a.object_name='TEST1' and a.DATA_OB...
