Another question:
you claim the following:
Efficient in handling large volumes of data
About how much volume are we speaking here?
It seems to me that for very large volumes the FULL OUTER JOIN can get problematic.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP