请各位看看下面的sql语句,会不会有性能上的问题
最主要的TD_GROUP_CUSTPRODUCT_REF表大概有100w条记录,不会有增长。
虽然看着有点眼晕,但还是希望各位能给点建议,因为我不想挨骂
在线等!
----
select distinct
TD_GROUP_CUSTPRODUCT_REF.GROUP_PRO_ID,
TD_GROUP_CUSTPRODUCT_REF.GROUP_ID,
TD_GROUP_CUSTPRODUCT_REF.CUST_NAME,
TD_GROUP_CUSTPRODUCT_REF.GROUP_TYPE_ID,
TD_GROUP_CUSTPRODUCT_REF.PRODUCT_ID,
TD_GROUP_CUSTPRODUCT_REF.PRODUCT_CODE,
TD_GROUP_CUSTPRODUCT_REF.PRODUCT_NAME,
TD_GROUP_CUSTPRODUCT_REF.PRODUCT_TYPE_ID,
TD_GROUP_CUSTPRODUCT_REF.DEAL_NAME,
TD_GROUP_CUSTPRODUCT_REF.DEAL_CERT_NUM,
TD_GROUP_CUSTPRODUCT_REF.DEAL_PHONE,
TD_GROUP_CUSTPRODUCT_REF.DEAL_EMAIL,
TD_GROUP_CUSTPRODUCT_REF.DEAL_RELA_METHOD,
TD_GROUP_CUSTPRODUCT_REF.CREATE_TIME,
TD_GROUP_CUSTPRODUCT_REF.CREATE_STAFF_ID,
TD_GROUP_CUSTPRODUCT_REF.CREATE_STAFF_NAME,
TD_GROUP_CUSTPRODUCT_REF.CREATE_REMARK,
TD_GROUP_CUSTPRODUCT_REF.CREATE_AREA_ID,
TD_GROUP_CUSTPRODUCT_REF.CREATE_AREA_NAME,
TD_GROUP_CUSTPRODUCT_REF.CREATE_COUNTRY_ID,
TD_GROUP_CUSTPRODUCT_REF.CREATE_COUNTRY_NAME,
TD_GROUP_CUSTPRODUCT_REF.STATE,
TD_GROUP_CUSTPRODUCT_REF.REMOVE_TIME,
TD_GROUP_CUSTPRODUCT_REF.REMOVE_STAFF_ID,
TD_GROUP_CUSTPRODUCT_REF.REMOVE_STAFF_NAME,
TD_GROUP_CUSTPRODUCT_REF.REMOVE_REASON,
TD_GROUP_CUSTPRODUCT_REF.LOSE_REASON,
TD_GROUP_CUSTPRODUCT_REF.REGISTER_STAFF_ID,
TD_GROUP_CUSTPRODUCT_REF.REGISTER_TIME,
TD_GROUP_CUSTPRODUCT_REF.REMOVE_STAFF_NAME,
count(distinct TD_GROUP_USER.GROUP_USER_ID),
count(distinct TD_GROUP_USERPROBUY.GROUP_USER_ID),
TD_GROUP_CUST. MGR_STAFF_ID
from TD_GROUP_CUSTPRODUCT_REF
left join TD_GROUP_USER on
(TD_GROUP_USER.GROUP_ID=TD_GROUP_CUSTPRODUCT_REF.GROUP_ID)
join TD_GROUP_USERPROBUY on
(TD_GROUP_USERPROBUY.GROUP_PRO_ID=TD_GROUP_CUSTPRODUCT_REF.GROUP_PRO_ID)
join TD_GROUP_CUST on
(TD_GROUP_CUST.GROUP_ID=TD_GROUP_CUSTPRODUCT_REF.GROUP_ID)
where TD_GROUP_USERPROBUY.GROUP_ID
in
(select TD_GROUP_CUST.GROUP_ID from TD_GROUP_CUST
where TD_GROUP_CUST.MGR_STAFF_ID='E00001')
and TD_GROUP_CUSTPRODUCT_REF.PRODUCT_ID=1
group by
TD_GROUP_CUSTPRODUCT_REF.GROUP_PRO_ID,
TD_GROUP_CUSTPRODUCT_REF.GROUP_ID,
TD_GROUP_CUSTPRODUCT_REF.CUST_NAME,
TD_GROUP_CUSTPRODUCT_REF.GROUP_TYPE_ID,
TD_GROUP_CUSTPRODUCT_REF.PRODUCT_ID,
TD_GROUP_CUSTPRODUCT_REF.PRODUCT_CODE,
TD_GROUP_CUSTPRODUCT_REF.PRODUCT_NAME,
TD_GROUP_CUSTPRODUCT_REF.PRODUCT_TYPE_ID,
TD_GROUP_CUSTPRODUCT_REF.DEAL_NAME,
TD_GROUP_CUSTPRODUCT_REF.DEAL_CERT_NUM,
TD_GROUP_CUSTPRODUCT_REF.DEAL_PHONE,
TD_GROUP_CUSTPRODUCT_REF.DEAL_EMAIL,
TD_GROUP_CUSTPRODUCT_REF.DEAL_RELA_METHOD,
TD_GROUP_CUSTPRODUCT_REF.CREATE_TIME,
TD_GROUP_CUSTPRODUCT_REF.CREATE_STAFF_ID,
TD_GROUP_CUSTPRODUCT_REF.CREATE_STAFF_NAME,
TD_GROUP_CUSTPRODUCT_REF.CREATE_REMARK,
TD_GROUP_CUSTPRODUCT_REF.CREATE_AREA_ID,
TD_GROUP_CUSTPRODUCT_REF.CREATE_AREA_NAME,
TD_GROUP_CUSTPRODUCT_REF.CREATE_COUNTRY_ID,
TD_GROUP_CUSTPRODUCT_REF.CREATE_COUNTRY_NAME,
TD_GROUP_CUSTPRODUCT_REF.STATE,
TD_GROUP_CUSTPRODUCT_REF.REMOVE_TIME,
TD_GROUP_CUSTPRODUCT_REF.REMOVE_STAFF_ID,
TD_GROUP_CUSTPRODUCT_REF.REMOVE_STAFF_NAME,
TD_GROUP_CUSTPRODUCT_REF.REMOVE_REASON,
TD_GROUP_CUSTPRODUCT_REF.LOSE_REASON,
TD_GROUP_CUSTPRODUCT_REF.REGISTER_STAFF_ID,
TD_GROUP_CUSTPRODUCT_REF.REGISTER_TIME,
TD_GROUP_CUSTPRODUCT_REF.REMOVE_STAFF_NAME,
TD_GROUP_CUST. MGR_STAFF_ID
having
TD_GROUP_CUST.MGR_STAFF_ID='E00001'
and
TD_GROUP_CUSTPRODUCT_REF.PRODUCT_ID=1;
|