【Oracle123】Oracle Select查询性能

 

参考：

https://www.cnblogs.com/mabiao008/p/6667680.html

https://www.cnblogs.com/liuzhenlei/p/7171168.html

 

1、select count(*) from sys_config_file where app_node ='wangjie' and to_char(create_date,'yyyy-mm-dd')=to_char(sysdate,'yyyy-mm-dd');

0.062秒

 

2、select count(*) from sys_config_file where app_node ='wangjie' and trunc(create_date)=trunc(sysdate);

0.093秒

3、select count(*) from sys_config_file where app_node ='wangjie' and create_date>=trunc(sysdate) and create_date<trunc(sysdate)+1;

0.015秒