oracle11g - Oracle Parameter Issue (Using OR Opeator) -

if execute both query individually not taking 4sec data, when combine both see query deadslow. appreciated

  query1:  select med_number,med_code,member_name,dob med med.med_code=:med_code     query2:  select red_number,red_name,red_code red  red.red_code =:red_code    final one:im passing 1 value @ time  select med_number,member_name,red_number,red_name med m left join red r on m.med_number=r.red_number (med.med_code=:med_code) or (red.red_code=:red_code) 

if @ execution plan 3 statements, you'll figure out. if you're not interested in figuring out , must execute 1 query, can execute this, using src determine rows below row source assuming have know difference , assuming numbers , names suitably equivalent data types:

select 1 src, med_number,member_name,dob med med.med_number=:med_number union select 2 src, red_number,red_name, null red  red.red_number=:red_number 

of course, if data types equivalent , dob not allowed null, suffice

select med_number,member_name,dob med med.med_number=:med_number union select red_number,red_name, null red  red.red_number=:red_number