2008-06-17 11:05:22 / Oracle开发
有以下查询的SQLselect t.a,t.b,max(t.data),fun(t.c)--自己写的函数from twhere t.date between to_date('2008-06-11','YYYY-MM-DD') and sysdategroup by t.a,t.b以上查询执行时间为115 sec----------------------------------------------------------------------------------------------------如果调整为select t.a,t.b,max(t.data),from twhere t.date between to_date('2008-06-11','YYYY-MM-DD') and sysdategroup by t.a,t.b查询执行时间为 0.609 sec-----------------------------
查看(485)
评论(10)