MySQL Forums
Forum List  »  Performance

Re: Slow Join Performance
Posted by: Ra Nala
Date: November 14, 2015 10:24AM


I am also facing performance issue while retrieving 4000000 data from database.

nearly i am using 10 tables joins , based on your input , if we have empty values for retrieving columns then if we update all values to NULL then our query process will be fast, is this correct ?? Please suggest me so that i will update accordingly.

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
October 06, 2015 08:45AM
October 06, 2015 02:38PM
October 06, 2015 03:42PM
Re: Slow Join Performance
November 14, 2015 10:24AM
November 26, 2015 02:39PM

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.