1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Adjust your join queries to always utilize indexes

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

  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