Get the most out of your Centmin Mod LEMP stack
Become a Member

Joins performed without indexes fix

Discussion in 'System Administration' started by pamamolf, Oct 13, 2014.

  1. pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    11:57 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    Hi

    I am wondering if i log that joins that perform without using indexes is there anything i can do to fix them and use indexes (maybe by creating indexes?) or is something that the developer must do in the software code?


    Thanks
     
  2. eva2000

    eva2000 Administrator Staff Member

    58,915
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    6:57 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+