I understand and agree with your comment about your biggest problem being
that you haven't yet figured out how to ask the right questions.
I have been using SQL for quite a few years now - and I STILL not yet
figured out how to ask the right questions.
When I first started using SQL - I was told - ALWAYS use the physical with
your selects (or omits) within the SQL script (although I could never find
I followed this directive UNTIL I had to run one particular (relatively
simple) SQL script.
It gave me the answers I was looking for - but it took a rather long time
to run - 20 minutes or so - a LARGE file
So just for the hell of it, I changed the script to use a logical (for the
selects and omits) and it literally took seconds - with the same results
Nowadays - I still tend to use the physical - but I keep the idea of using
a logical in the back of my head