标签：优化
大神们过来看看,sql优化
本人有一个表:s_exp_shpping 本人想找出批次号 + 收件人名称 + 地址 + 电话都一样,并且最少出现过两次的记录,本人用下面方法运行时用了7s,有没有办法更快点? select t.BATCH_NUM, t.name, t.SHPPING_ADDRESS, t.PHONE_NUMBER from s_exp_shpping t where ((……
问一下带in 和 子查询的sql语句怎么进行优化？
UPDATE user_bank_info set fisused = 2 where fuserid in ( SELECT userid FROM ( select DISTINCT ubi.fuserid as userid from customer as c JOIN user_bank_info as ubi ON c.fuserid =ubi……
哪个帮本人优化下这个sql语句，跪谢了……
SELECT t.* FROM (SELECT t1.USER_ID,t3.CUST_ID,t3.BILL_ID AS MSISDN,t3.CREATE_DATE AS ACTIVE_DATE,t1.ACCT_ID,t2.CUST_GROUP FROM so1.ins_accrel_571 t1,so1.um_cm_account t2 ,so1.ins_u……
mysql 多表连接语句优化讨教
SELECT * from (SELECT `dili_c`.*, `dili_uf`.`fchannelcode`,`dili_uf`.`fcashbalance`, `dili_uf`.`fchannelbalance`, `dili_uf`.`favailablebalance`, `dili_uf`.`fholdbalance`, (SELECT……
一个sql执行了37分钟，们这个语句怎么优化呢？
执行下列sql语句用时37分钟，这个语句怎么优化呢？ ======================================================================================= SELECT ri.rep_id AS rep_ite_rep_id, rd.rep_ite_id, ri.rep_ite_ty……
求优化sql 语句 ，写的很长，能不能优化下！
SELECT * FROM (SELECT a.area_name,a.area_id FROM area AS a WHERE a.area_pid=104 ) d LEFT JOIN (SELECT counts ,city FROM (SELECT city,province ,COUNT(*) ……