List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:October 6 2011 2:59pm
Subject:MySQL Indexes
View as plain text  
Hi,

Can anyone help and offer some advice with regards MySQL indexes.  Basically
we have a number of different tables all of which have the obviously primary
keys.  We then have some queries using JOIN statements that run slowly than
we wanted.  How many indexes are recommended per table ?  For example should
I have a index on all fields that will be used in a WHERE statement ?
 Should the indexes be created with multiple fields ?  A example  of two
basic queries

SELECT auto_id, name, score
FROM test_table
WHERE score > 10
ORDER BY score DESC


SELECT auto_id, name, score
FROM test_table
WHERE score > 10
AND name Like '%Red%'
ORDER BY score DESC

How many indexes should be created for these two queries ?

Thanks,
Neil

Thread
MySQL IndexesTompkins Neil6 Oct
  • Re: MySQL IndexesMichael Dykman6 Oct
    • Re: MySQL IndexesNeil Tompkins6 Oct
      • Re: MySQL IndexesMichael Dykman7 Oct
        • Re: MySQL IndexesNuno Tavares7 Oct
          • Re: MySQL IndexesBrandon Phelps7 Oct
            • Re: MySQL IndexesMichael Dykman7 Oct
              • Re: MySQL IndexesReindl Harald7 Oct
                • Re: MySQL IndexesMichael Dykman7 Oct
                  • Re: MySQL IndexesNeil Tompkins7 Oct
                    • Re: MySQL IndexesMichael Dykman7 Oct
        • Re: MySQL IndexesTompkins Neil7 Oct
          • Re: MySQL IndexesMichael Dykman7 Oct
            • Re: MySQL IndexesNeil Tompkins7 Oct
              • Re: MySQL Indexesmos7 Oct