MySQL Forums
Forum List  »  Performance

Re: distinct clause issue for 600000 records
Posted by: Ra Nala
Date: November 13, 2015 12:37AM

Thank you. below is the SHOW VARIABLES and query for my database, please advise.

my query
select distinct as prdsld,
psrl.psn as psn ,
psrl.bdate as bdate,
psrl.sdate as sdate ,
psrl.idate as idate,
psrl.i_no as i_no ,
psrl.tid as tid,
rn.scode as scode,
rn.rtype as rtype ,
rn.cdate as cdate ,
rn.rdate as rdate ,
rn.rreference as rreference,
rn.rsource as rsource ,
rn.r_industry as r_industry ,
r_application as r_application ,
rn.er_reference as er_reference,
rn.i_no as rn_i_no,
rn.s_per as s_per,
psrl.created_date od_created_date,
psrl.updated_date od_updated_date,
bcu.code as cbe_code,
bcu.type_code as cbe_type_code,
ead.address_1 as c_address_1,
ead.address_2 as c_address_2,
ead.address_3 as c_address_3, as c_city, as c_zip, as c_email,
rn.p_price as p_price,
rn.p_date as p_date,
be1.code r_be_code,
be1.type_code r_be_type_code,
ea2.address_1 r_be_address_1,
ea2.address_2 r_be_address_2,
ea2.address_3 r_be_address_3, r_be_city, r_be_email, r_be_zip ,
rn.prdgnd as prdgnd,
psrl.ship_bed as ship_bed,
prd.prdd as modeld,
psrltn.rltd_psn as rltd_psn,
psrltn.rmod as rmod
from prdsl psrl
left join prd prd on psrl.prdd=prd.prdd
left join be_en beship on
left join be_en beinv on
left join be_en reginv on
left join prdgn rn on and rn.scode ='abc' and rn.rtype ='xyz'
left join be_en be1 on = rn.invoice_bed
left join be_gn_ad bea1 on bea1.bed = and bea1.is_preferred = 'Y'
left join enad ea2 on = bea1.be_addressd and ea2.address_type = 'Bil'
left join be_en bcu on
left join enad ead on rn.c_addressd
left join prrl psrltn on psrltn.prdsld =

Options: ReplyQuote

Written By
Re: distinct clause issue for 600000 records
November 13, 2015 12:37AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.