Unanswered: Optimizing query performance when joining multiple tables
I am experiencing performance problems on my queries. When i query from one table queries are fast but when i query on more tables by joining tables my queries take long. i tried using indexes on columns that are queried most oftenly but it is not helping. Do you know of any way how i can solve this issue?
Could you post a)the type of database server b)the query c)the index types \ structures
here is my query and i am running it on Oracle application express (APEX)
select /*+ INDEX (HUAWEIDATA_TB MSISDN_IDX )*/
from cdruser.huaweidata_tb@MTCCDRT a,
where open_date >= to_date(:P405_start_date,'dd-mon-rrrr hh24miss') and
open_date <= to_date(:P405_end_date,'dd-mon-rrrr hh24miss')
and (record_type = '12' or record_type = '13' or record_type = '14')
and a.open_date = b.hd_cocc_date (+)
and a.local_seq_nr = b.hd_cocc_local_seq_nr (+)
and a.msisdn_nr = :P405_msisdn_number
order by open_date
when i query on more than one day it takes very long and does not return anything you will have to stop it because its taking long.