blogjava-凯发k8网页登录
blogjava-凯发k8网页登录http://www.blogjava.net/jack2007/commentsrss.aspxjava, c , linux c, c#.net 技术,软件架构,领域建模,it 项目管理
zh-cnsat, 20 nov 2010 15:47:14 gmtsat, 20 nov 2010 15:47:14 gmtcnblogs- re: 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。
]]> - 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
]]> - 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
]]> - 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
]]> - 关于”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占用率明显比第一条低。
”
]]> - 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谢谢了!!
]]> - 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
我也需要下载这个视频学习。
谢谢
]]> - 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先谢谢啦
]]> - 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
]]> - 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? --!
]]> - 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
]]> - 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
]]> - 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
]]> - 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谢谢!
]]> - 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
]]> - 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
]]> - 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
]]> - 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
]]> - 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
]]> - 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
]]> - 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
]]> - 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#308788buy" target="_new" rel="nofollow">http://www.primethesis.com">buy thesis services was to purchase the the best legal dissertation about this good post at the dissertation services.
]]> - 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
]]> - 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
]]> - 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
]]>