Adjust your join queries to always utilize indexes

Discussion in 'Databases' started by ASTRAPI, Dec 19, 2009.

0
  1. #1
    How can i do this:

    Adjust your join queries to always utilize indexes
    ?

    Thank you

    Database Mysql and i use phpmyadmin.
     
    ASTRAPI, Dec 19, 2009 IP
  2. cahya77

    cahya77 Member

    Messages:
    80
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #2
    hi...
    i'm not understand what did your question mean,,,,
    can you more describe it...
    thx...
     
    cahya77, Dec 19, 2009 IP
  3. ASTRAPI

    ASTRAPI Guest

    Messages:
    500
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    This is a recomandation to do for better performance of mysql form sqltuner script :)
     
    ASTRAPI, Dec 19, 2009 IP
  4. jedi.knight

    jedi.knight Peon

    Messages:
    20
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Can you list the indexes you have and queries that involve table joins (use more than one table)?
     
    jedi.knight, Dec 20, 2009 IP
  5. ASTRAPI

    ASTRAPI Guest

    Messages:
    500
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    i have no idea :(
     
    ASTRAPI, Dec 21, 2009 IP