Difference between in IN and EXISTS in Teradata SQL?

Performance wise both should be same with less no of records.If no of records will be more, EXISTS is faster than IN.


Mostly IN is used in case of subqueries and EXISTS is used in case of correlated subqueries.

1 comment:

Subscribe to: Post Comments (Atom)