You Asked
Hi Tom,
I need to know how the where clause is effecting my query.
I have a table ABC where it has batch_id. It has 1L rows. Its daily truncated table. so it will have only one batch_id.
table1 = ABC
table2 = XYZ
select * from ABC t1, XYZ t2 where batch_id = 111
and t1.col1 = t2.col2
the above query is taking 20+ minutes to retrieve data.
the below query is taking hardly 6s.
select * from ABC t1, XYZ t2 where t1.col1 = t2.col2;
Just want it understand why its taking time with just batch_id in where clause.
and Connor said...
Is this answer out of date? If it is, please let us know via a Comment