select vrowid rid
from cux_mtl_system_items_v e
where e.ORGANIZATION_CODE = '100'
order by DESCRIPTION asc
如上SQL,去掉ORDER BY 1秒内能查出来,如果加上ORDER BY 至少要20秒以上,这是为啥啊
我是在PLSQL上面操作的
select vrowid rid
from cux_mtl_system_items_v e
where e.ORGANIZATION_CODE = '100'
order by DESCRIPTION asc
如上SQL,去掉ORDER BY 1秒内能查出来,如果加上ORDER BY 至少要20秒以上,这是为啥啊
我是在PLSQL上面操作的