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.