I have a delete statement which is consuming more time.
Not sure why would you get the count mismatch. The joining conditions for the two tables are same and EXISTS kind of serve as the inner join so its not making sense to have count mismatch.
Did you try the SELECT statement to check the row counts in both of the cases? Do they differ as well?
Ya i was mistaken . i got the same count. but original qry have better performance than EXISTS.
Can u pls suggest how can we tune this.Table A is a large table having huge volume of data. and Table B is small Table.
All the columns mentioned in the where condition are Indexed.