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.
from firstname.lastname@example.org a,
It takes hours to run.
Thanks in advance.