https://blog.youkuaiyun.com/JStarXzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/JStarX/article/details/6827538https://blog.youkuaiyun.com/JStarX/article/details/6827538JStarXThu, 29 Sep 2011 10:18:03 +0800https://blog.youkuaiyun.com/JStarX/article/details/6761652https://blog.youkuaiyun.com/JStarX/article/details/6761652JStarXMon, 12 Sep 2011 23:47:27 +0800https://blog.youkuaiyun.com/JStarX/article/details/83806296https://blog.youkuaiyun.com/JStarX/article/details/83806296JStarXTue, 04 Jan 2011 10:46:58 +0800https://blog.youkuaiyun.com/JStarX/article/details/83802758https://blog.youkuaiyun.com/JStarX/article/details/83802758JStarXMon, 27 Dec 2010 17:24:53 +0800https://blog.youkuaiyun.com/JStarX/article/details/83770893https://blog.youkuaiyun.com/JStarX/article/details/83770893JStarXSun, 28 Nov 2010 21:18:33 +0800https://blog.youkuaiyun.com/JStarX/article/details/83770876https://blog.youkuaiyun.com/JStarX/article/details/83770876JStarXSun, 28 Nov 2010 20:56:12 +0800https://blog.youkuaiyun.com/JStarX/article/details/83770860https://blog.youkuaiyun.com/JStarX/article/details/83770860JStarXSun, 28 Nov 2010 20:24:49 +0800https://blog.youkuaiyun.com/JStarX/article/details/6029464https://blog.youkuaiyun.com/JStarX/article/details/6029464JStarXTue, 23 Nov 2010 13:00:00 +0800　order by 的数值型灵活使用 　　代码: 　　select * from table_a where id=p_id order by decode(函数,'asc',1,'desc',-1)*jsny; 　　　　　　
控制试图的访问时间： 　　6. 代码: 　　create view ... 　　as 　　select ... from where exists(select x from dual where sysdate>=8:00am and sysdate<=5:0]]>https://blog.youkuaiyun.com/JStarX/article/details/6029409https://blog.youkuaiyun.com/JStarX/article/details/6029409JStarXTue, 23 Nov 2010 12:34:00 +0800原文链接：http://hi.baidu.com/%F5%CC%C4%A7/blog/item/affd5c01f0ad1b047bec2cd6.html
最近在JavaEye上发现好多同志对sql的优化好像是知道的很少，最近总结了几条仅供参考，不过除少数可能要依情况而定，大多数还是相当有效的。
【注：以下说的（低效）与（高效）都是相当来说的。】

1、Where子句中的连接顺序：
ORACLE采用自下而上的顺序解析WHERE子句。 https://blog.youkuaiyun.com/JStarX/article/details/83766363https://blog.youkuaiyun.com/JStarX/article/details/83766363JStarXThu, 18 Nov 2010 10:18:20 +0800https://blog.youkuaiyun.com/JStarX/article/details/83741289https://blog.youkuaiyun.com/JStarX/article/details/83741289JStarXTue, 02 Nov 2010 19:33:12 +0800https://blog.youkuaiyun.com/JStarX/article/details/83741273https://blog.youkuaiyun.com/JStarX/article/details/83741273JStarXTue, 02 Nov 2010 18:54:48 +0800https://blog.youkuaiyun.com/JStarX/article/details/5826683https://blog.youkuaiyun.com/JStarX/article/details/5826683JStarXFri, 20 Aug 2010 15:27:00 +0800  前几天部署普兰，主要是配置Apache中的CGI组件。当时稀里糊涂的一顿该，没明白为啥这么做。哎，这是一大错。明白为啥这么做，理解这个过程，对普兰的发布至少很清晰了。
   先帖出配置后的结果：http://localhost：8000/cgi-bin/arcCGI6.EXE.服务器通过这个url找到conf下web.xml中的
 
        cgi
  ]]>