3条sql语句的性能对比
来源:互联网 发布:stata和python 编辑:程序博客网 时间:2024/06/11 17:13
有谁能分析出三条语句的执行性能吗
select a.*,b.* FROM tb_order_user_229 a,tb_order_info_user_229 b WHERE a.order_id=b.order_id and a.user_id = 45923430 AND a.trade_code != 'Z0001' order by a.create_time desc limit 100,300
SELECT a.order_id, a.trade_code, a.user_id, a.user_name, a.create_time, a.cancel_time, a.pay_time, a.pay_account, a.seller_id, a.seller_name, a.pay_channel, a.pay_id, a.closing_price, a.consumer_details, a.third_id, a.express_id, a.express_no, a.province_id, a.city_id, a.county_id, a.receiver_address, a.receiver_name, a.receiver_mobile, a.receiver_tele, a.order_state, a.seller_comment, a.buyer_comment, a.source, a.last_update_time, a.last_update_user_id, a.create_user_id,a.pay_state,a.address_id,a.province_name, a.city_name,a.county_name,a.post_code,a.deliver_time, a.success_time, a.complain_state, a.after_sale_state, a.settlement_state, a.postage, a.is_buyer_delete, a.score,a.score_platform_id,a.order_state_type, a.order_state_type_desc,a.settlement_time,a.coupon_no,a.coupon_price,a.order_tag,a.express_name, a.wi, a.from_source, a.order_id, a.trade_pay_id, a.discount_category, a.discount_id, a.discount_type, a.discount_desc, a.discount_satisfy_rule, a.discount_price, b.product_id, b.class_num, b.seller_class_num, b.sku_num, b.sku_desc, b.cur_price, b.org_price, b.count, b.postage, b.product_snapshoot_id, b.comment, b.last_update_time, b.last_update_user_id, b.create_time, b.create_user_id,b.location,b.profile,b.shelf,b.product_name,b.images_url,b.type,b.level,b.score, b.cate,b.promotion_id,b.discount_price,b.coupon_price from (select a.order_id FROM tb_order_user_229 a, tb_order_info_user_229 b WHERE a.order_id = b.order_id AND a.user_id = 45923430 AND a.trade_code != 'Z0001' GROUP BY a.order_id order by a.create_time desc limit 100 ,530 )c, tb_order_user_229 a,tb_order_info_user_229 b where c.order_id = a.order_id AND c.order_id = b.order_id
SELECT a.order_id, a.trade_code, a.user_id, a.user_name, a.create_time, a.cancel_time, a.pay_time, a.pay_account, a.seller_id, a.seller_name, a.pay_channel, a.pay_id, a.closing_price, a.consumer_details, a.third_id, a.express_id, a.express_no, a.province_id, a.city_id, a.county_id, a.receiver_address, a.receiver_name, a.receiver_mobile, a.receiver_tele, a.order_state, a.seller_comment, a.buyer_comment, a.source, a.last_update_time, a.last_update_user_id, a.create_user_id,a.pay_state,a.address_id,a.province_name, a.city_name,a.county_name,a.post_code,a.deliver_time, a.success_time, a.complain_state, a.after_sale_state, a.settlement_state, a.postage, a.is_buyer_delete, a.score,a.score_platform_id,a.order_state_type, a.order_state_type_desc,a.settlement_time,a.coupon_no,a.coupon_price,a.order_tag,a.express_name, a.wi, a.from_source, a.order_id, a.trade_pay_id, a.discount_category, a.discount_id, a.discount_type, a.discount_desc, a.discount_satisfy_rule, a.discount_price, b.product_id, b.class_num, b.seller_class_num, b.sku_num, b.sku_desc, b.cur_price, b.org_price, b.count, b.postage, b.product_snapshoot_id, b.comment, b.last_update_time, b.last_update_user_id, b.create_time, b.create_user_id,b.location,b.profile,b.shelf,b.product_name,b.images_url,b.type,b.level,b.score, b.cate,b.promotion_id,b.discount_price,b.coupon_price from ( select t.* from tb_order_user_229 t where t.order_id in (select DISTINCT a.order_id FROM tb_order_user_229 a, tb_order_info_user_229 b WHERE a.order_id = b.order_id AND a.user_id = 45923430 AND a.trade_code != 'Z0001' ) order by t.create_time desc limit 100,300 )a,tb_order_info_user_229 b where a.order_id=b.order_id #2014-09-24 16:11:50,558 [pool-2-thread-24] DEBUG sql.PreparedStatement - ==> Parameters: 6760(Integer), 10(Integer)
0 0
- 3条sql语句的性能对比
- 写出高性能SQL语句的35条方法
- 写出高性能SQL语句的35条方法
- 写出高性能SQL语句的35条方法分析
- 写出高性能SQL语句的35条方法
- 高性能SQL语句的35条方法
- 写出高性能SQL语句的十三条法则
- 写出高性能SQL语句的35条方法
- 写出高性能SQL语句的35条方法 分享
- 写出高性能SQL语句的35条方法分析
- 写出高性能SQL语句的35条方法分析
- 对sql进行性能分析的两条语句
- SQL 查询语句性能对比分析
- 条SQL语句的迷惑。
- 常用的三条分页SQL语句(存储过程)的性能比较
- Oracle 如何根据动态性能视图来查看某条SQL语句的执行计划
- 关于SQL语句的性能
- 性能优良的sql语句
- hdu1372 Knight Moves(BFS)
- 【探索】QQ弹窗广 告解决方法
- 鸟哥的私房菜:Bash shell(三)-命令别名与历史指令
- 用JS判断两个数字的大小
- struct与typedef struct的区别
- 3条sql语句的性能对比
- 最近工作总结
- Android_完美退出应用方法
- 【转】分布式集群系统下的高可用session解决方案
- opencv2.49+vs2010的配置出现1>LINK : fatal error LNK1104: 无法打开文件“…….lib”解决方案
- 小波变换 opencv
- 《数据结构》实验1.1 java 中的运用
- Hive简介
- Java没有头文件的原因