08 2015 档案

优化sql，返回行数少情况下，NL比hash快好多
摘要：sql如下select t.id, t.value, tt.sort as sortno from ENGINEERING_TYPE t left join ENGINEERING_TYPE tt on t.parentid = tt.id where t.delete_flag = 0... 阅读全文

posted @ 2015-08-28 16:24 Roc.Sun 阅读(497) 评论(0) 推荐(0)

简单改写SQL达到优化目的
摘要：select *from (select t.row_id,t.supplier_name,t.tel,address,t.contact,t.contact_post,t.contact_mobi,t.contact_tel,casewhen project_supp_type = 0 thent... 阅读全文

posted @ 2015-08-28 11:32 Roc.Sun 阅读(330) 评论(0) 推荐(0)

导航