Brad Fitzpatrick (brad) wrote,
Brad Fitzpatrick

  • Mood:

use index

I learned a new MySQL trick today... USE INDEX (..)

MySQL's query optimizer sucks a dick. I'm not sure I'll ever write another query without explicitly specifying which index to use.

Why did I never see that before? I thought I had that manual memorized. :-(
Tags: mysql, tech

  • Happy Birthday!

    Happy 20th Birthday, LiveJournal! 🐐🎂🎉

  • hi

    Posting from the iPhone app. Maybe I'm unblocked now.

  • Why, hello...

    Long time no see. How's my baby doing?

  • Post a new comment


    default userpic

    Your reply will be screened

    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.