诡异的MySql执行计划的更改
摘要:
SQL是在从库上执行正常的执行计划:explain SELECT h.id hid,r.rate rate FROM ORDER_CUST_INFO o, exchange_rate r, HOTEL_INFO h where o.group_id = h.group_id and o.currency = r.type and r.type != 'CNY' and h.type = 'OWNER' and h.apply_status = 'CHECKED' and h.online = true and h.online_status = 阅读全文
posted @ 2013-03-23 23:45 NanguoCoffee 阅读(991) 评论(0) 推荐(0) 编辑