I wrote a query (with lots of help, see my painfully plentiful other threads) using a correlated subquery and it takes 5.78 seconds PER RECORD to return results. The SAME query, only I select the ...

It's been far too long since I did any real db work, and even then it was simple stuff. Now I feel in way over my head and I don't remember the basic vocabulary to help find the answers I need.

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...