Optimizing this joined query that's ignoring indexes

  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:
    778
    Likes Received:
    149
    Trophy Points:
    830
    Location:
    Russian Federation
    Hi.
    Provide ddl-statements of tables,index.
    Provide sql query.