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
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.