Ok, I’m going to show some ignorance here. I searched around and couldn’t find a whole lot, even though I’m sure the answer to my question is probably simple. I’m thinking this is most likely a case where you just have to know what to search for to find it. Anyway…
When I set up a new table index for a table in phpMyAdmin, is there anything I need to do in my server-side code or MySQL queries to interact with those indexes? Or, does the DBMS simply determine which index is best on a case by case basis? If the latter is the case, is there any way to make sure a query uses a particular index to keep queries speedy?
Thanks!
