pooja74
asked on
Query taking very long time to run
My following query is taking very long time to run.Please suggest the ways to tune this query.
Key1 and key2 are indexed columns.tab2 is a partitioned table.tab1 is in other schema.
Select
CREDITORS_MEETING_STATUS_C
TRANSFER,
FLG,
from tab1@mdm.com a,
tab2 b
where a.key1=b.key2
and program_id=1;
It takes hours to run.
Thanks in advance.
Key1 and key2 are indexed columns.tab2 is a partitioned table.tab1 is in other schema.
Select
CREDITORS_MEETING_STATUS_C
TRANSFER,
FLG,
from tab1@mdm.com a,
tab2 b
where a.key1=b.key2
and program_id=1;
It takes hours to run.
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Another alternative would be to create a local copy of tab1@mdm.com before running this query (via materialized views or any other replication technique), and then you can query 2 tables on the same database which will obviosly be much quicker.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.