Brad Fitzpatrick (brad) wrote,
Brad Fitzpatrick
brad

  • 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
Subscribe
  • Post a new comment

    Error

    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.
  • 9 comments