1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Optimizing this joined query that's ignoring indexes

Discussion in 'MySQL Forums' started by clem_c_rock, Apr 7, 2014.

  1. clem_c_rock

    clem_c_rock Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Hello,
    I have this query and I cannot figure out how to optimize this query any further. Since it’s a joined query, I can’t seem to get it to honor any of the indexes.
    Here’s the monstrosity:
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.
    Provide ddl-statements of tables,index.
    Provide sql query.