Susan Davis (futabachan) wrote,
Susan Davis

  • Mood:
  • Music:

Learning about good SQL performance?

I've worked with eight or nine different database vendors in my career, and I've learned enough SQL to avoid obvious antipatterns (e.g. the N+1 selects problem) and pitfalls (e.g. DB2 page-level locking), and some optimizations by rote (e.g. expanding transitive relationships in selects). I still don't have a particularly good handle on which of two or more competing ways to accomplish something in SQL is more efficient, and it's not only not obvious, it's sometimes counterintuitive.

Can anyone recommend good references, both vendor-specific and in general, that will let me reason about the performance of SQL that I'm writing (or rewriting)? Thanks in advance....
Tags: geek, work

  • "That's it! I'm moving to Canada!"

    I've heard quite a few American friends postulate moving to Canada if the Presidential election in the fall doesn't go their way. Amanda and I moved…

  • Remembering Our Dead

    Today is the Transgender Day of Remembrance. For folks in the GTA, observances will be held at 7 PM at the 519 Centre on Church Street, and in…

  • Victory! The lesser victory of the two, but still....

    The President signed the Matthew Sheppard hate crimes bill today. It's been years since I've been an activist, but a trans-inclusive hate crimes bill…

  • Post a new comment


    default userpic

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.