From your experience, what is the best option for comparing contents of two tables? Both ways!
- full outer join?
- minus applied both ways?
- not exist applied both ways?
Let's say that we have 2 tables: extract and extract_previous and every day you have to check the diff between them.
thanks in advance!