BlogJava-<span style="color: black; font-family: 'Blackadder ITC'">走在架构师的大道上 Jack.Wang's home</span>-最新评论http://www.blogjava.net/Jack2007/CommentsRSS.aspxJava, C++, linux c, C#.net 技术,软件架构,领域建模,IT 项目管理 <span id="dict_daily"> <a href="http://dict.cn/" target="_blank">Dict.CN 在线词典, 英语学习, 在线翻译</a> </span> <script language="JavaScript" src="http://dict.cn/daily.php" defer="defer"> </script> zh-cnSat, 20 Nov 2010 15:47:14 GMTSat, 20 Nov 2010 15:47:14 GMTcnblogsre: C#与Java之比较http://www.blogjava.net/Jack2007/archive/2010/11/16/194230.html#338215纯粹路过的纯粹路过的Tue, 16 Nov 2010 15:09:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/11/16/194230.html#338215因为WIN32上的虚拟机就是C++实现的，函数库自然是扔DLL了，JDK自带的NATIVE方法指引着你瞄瞄JDK带的DLL。

纯粹路过的 2010-11-16 23:09 发表评论
]]>re: Flex 视频大全『可下载』http://www.blogjava.net/Jack2007/archive/2010/09/26/227125.html#332973ssssSun, 26 Sep 2010 08:59:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/09/26/227125.html#332973

ss 2010-09-26 16:59 发表评论
]]>re: NesQQ 项目控制文件分享http://www.blogjava.net/Jack2007/archive/2010/09/05/158835.html#331069觉得糊精觉得糊精Sun, 05 Sep 2010 02:57:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/09/05/158835.html#331069

觉得糊精 2010-09-05 10:57 发表评论
]]>re: 软件架构设计--好书推荐http://www.blogjava.net/Jack2007/archive/2010/07/29/199646.html#327424douglassdouglassThu, 29 Jul 2010 06:01:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/07/29/199646.html#327424

douglass 2010-07-29 14:01 发表评论
]]>关于”WHERE后面的条件顺序影响“这一段，是不是有问题？http://www.blogjava.net/Jack2007/archive/2010/07/14/211728.html#326083yangzhjyangzhjWed, 14 Jul 2010 06:36:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/07/14/211728.html#326083WHERE后面的条件顺序影响
Oracle从下到上处理Where子句中多个查询条件，所以表连接语句应写在其他Where条件前，可以过滤掉最大数量记录的条件必须写在Where子句的末尾。
WHERE子句后面的条件顺序对大数据量表的查询会产生直接的影响，如
Select * from zl_yhjbqk where dy_dj = '1KV以下' and xh_bz=1
Select * from zl_yhjbqk where xh_bz=1 and dy_dj = '1KV以下'
以上两个SQL中dy_dj（电压等级）及xh_bz（销户标志）两个字段都没进行索引，所以执行的时候都是全表扫描，第一条SQL的dy_dj = '1KV以下'条件在记录集内比率为99%，而xh_bz=1的比率只为0.5%，在进行第一条SQL的时候99%条记录都进行dy_dj及xh_bz的比较，而在进行第二条SQL的时候0.5%条记录都进行dy_dj及xh_bz的比较，以此可以得出第二条SQL的CPU占用率明显比第一条低。

“可以过滤掉最大数量记录的条件必须写在Where子句的末尾”
而作者举的例子中，显然第一条SQL更符合这个条件，
但得出的结果是：“以此可以得出第二条SQL的CPU占用率明显比第一条低。
”


yangzhj 2010-07-14 14:36 发表评论
]]>re: Flex 视频大全『可下载』http://www.blogjava.net/Jack2007/archive/2010/07/08/227125.html#325533阿曼阿曼Thu, 08 Jul 2010 03:11:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/07/08/227125.html#325533谢谢了！！

阿曼 2010-07-08 11:11 发表评论
]]>re: Flex 视频大全『可下载』http://www.blogjava.net/Jack2007/archive/2010/05/10/227125.html#320522梁远华梁远华Mon, 10 May 2010 12:24:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/05/10/227125.html#320522或
leung@techsailor.com

我也需要下载这个视频学习。
谢谢

梁远华 2010-05-10 20:24 发表评论
]]>re: Flex 视频大全『可下载』http://www.blogjava.net/Jack2007/archive/2010/04/20/227125.html#318876李子李子Tue, 20 Apr 2010 09:24:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/04/20/227125.html#318876先谢谢啦

李子 2010-04-20 17:24 发表评论
]]>re: Flex 视频大全『可下载』http://www.blogjava.net/Jack2007/archive/2010/04/12/227125.html#318049时磊时磊Mon, 12 Apr 2010 05:00:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/04/12/227125.html#318049

时磊 2010-04-12 13:00 发表评论
]]>re: 软件架构设计参考文件http://www.blogjava.net/Jack2007/archive/2010/03/31/299238.html#317074robrobWed, 31 Mar 2010 08:34:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/03/31/299238.html#317074........what's that?
advertising？ --!

rob 2010-03-31 16:34 发表评论
]]>re: 计算字符串相似度的简易算法http://www.blogjava.net/Jack2007/archive/2010/03/25/251984.html#316499szxszxThu, 25 Mar 2010 01:18:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/03/25/251984.html#316499

szx 2010-03-25 09:18 发表评论
]]>re: SSO单点登录解决方案[转载][未登录]http://www.blogjava.net/Jack2007/archive/2010/03/22/191795.html#316223gongmingwindgongmingwindMon, 22 Mar 2010 15:37:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/03/22/191795.html#316223

gongmingwind 2010-03-22 23:37 发表评论
]]>re: NesQQ 项目控制文件分享http://www.blogjava.net/Jack2007/archive/2010/03/12/158835.html#315294LIXUFENGLIXUFENGFri, 12 Mar 2010 08:50:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/03/12/158835.html#315294

LIXUFENG 2010-03-12 16:50 发表评论
]]>re: SSO单点登录解决方案[转载]http://www.blogjava.net/Jack2007/archive/2010/03/04/191795.html#314492宋标宋标Thu, 04 Mar 2010 02:47:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/03/04/191795.html#314492谢谢！

宋标 2010-03-04 10:47 发表评论
]]>re: Flex 视频大全『可下载』http://www.blogjava.net/Jack2007/archive/2010/01/29/227125.html#311190dudupppdudupppFri, 29 Jan 2010 02:58:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/01/29/227125.html#311190

duduppp 2010-01-29 10:58 发表评论
]]>re: Flex 视频大全『可下载』http://www.blogjava.net/Jack2007/archive/2010/01/22/227125.html#310540LeeGangLeeGangFri, 22 Jan 2010 08:44:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/01/22/227125.html#310540

LeeGang 2010-01-22 16:44 发表评论
]]>re: Flex 视频大全『可下载』[未登录]http://www.blogjava.net/Jack2007/archive/2010/01/21/227125.html#310394梁健梁健Thu, 21 Jan 2010 07:11:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/01/21/227125.html#310394

梁健 2010-01-21 15:11 发表评论
]]>re: Google 架构之学习http://www.blogjava.net/Jack2007/archive/2010/01/16/186980.html#309786happyhappySat, 16 Jan 2010 10:03:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/01/16/186980.html#309786http://blog.sina.com.cn/mpl398235717

happy 2010-01-16 18:03 发表评论
]]>re: Flex 视频大全『可下载』http://www.blogjava.net/Jack2007/archive/2010/01/16/227125.html#309757李星星李星星Sat, 16 Jan 2010 01:22:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/01/16/227125.html#309757

李星星 2010-01-16 09:22 发表评论
]]>re: SSO单点登录解决方案[转载]http://www.blogjava.net/Jack2007/archive/2010/01/14/191795.html#309474张敏张敏Thu, 14 Jan 2010 08:51:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/01/14/191795.html#309474

张敏 2010-01-14 16:51 发表评论
]]>re: Flex 视频大全『可下载』http://www.blogjava.net/Jack2007/archive/2010/01/14/227125.html#309425scottescotteThu, 14 Jan 2010 04:07:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/01/14/227125.html#309425

scotte 2010-01-14 12:07 发表评论
]]>re: 软件架构设计参考文件http://www.blogjava.net/Jack2007/archive/2010/01/08/299238.html#308788GeenapRGeenapRFri, 08 Jan 2010 15:05:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/01/08/299238.html#308788http://www.primethesis.com">buy thesis</a> services was to purchase the the best legal dissertation about this good post at the <a href="http://www.primethesis.com">custom dissertation</a> services.

GeenapR 2010-01-08 23:05 发表评论
]]>re: NesQQ 项目控制文件分享http://www.blogjava.net/Jack2007/archive/2010/01/08/158835.html#30863155665566Thu, 07 Jan 2010 17:41:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/01/08/158835.html#308631

5566 2010-01-08 01:41 发表评论
]]>re: Flex 视频大全『可下载』http://www.blogjava.net/Jack2007/archive/2010/01/04/227125.html#308132yueliangyueliangMon, 04 Jan 2010 01:51:00 GMThttp://www.blogjava.net/Jack2007/archive/2010/01/04/227125.html#308132

yueliang 2010-01-04 09:51 发表评论
]]>re: NesQQ 项目控制文件分享[未登录]http://www.blogjava.net/Jack2007/archive/2009/12/20/158835.html#306718天天天天Sun, 20 Dec 2009 01:34:00 GMThttp://www.blogjava.net/Jack2007/archive/2009/12/20/158835.html#306718

天天 2009-12-20 09:34 发表评论
]]>