MIN、MAX优化

http://blog.csdn.net/robinson1988/article/details/6623773

 

select (select min(object_id) min_id from test a),(select max(object_id) max_id from test b) from dual; 

select (select /*+ index_asc(test  i_object_id) */ object_id from test where rownum=1) min 
86.,(select /*+ index_desc(test  i_object_id) */ object_id from test where rownum=1) max from dual;