General rule of thumb - create indexes on any fields which will be used in the conditional part of a select statement, whether where or join. Since you are working with tables, you can save yourself a lot of typing by dropping the "table_" from the table names. After all, that's what they are. (You can do this unless you've gone too far with your system.)
Miles Thompson At 02:15 PM 8/14/2002 +0200, lallous wrote: >give this query: > > SELECT > table_routing.id AS routeid, > table_pricing.units AS price, > table_routing.provider AS providerid, > table_country.name AS countryname, > table_country.id AS countrycode > FROM > table_pricing, > table_routing, > table_country > WHERE > table_country.id = table_routing.country > AND > table_routing.country = table_pricing.country > AND > table_routing.provider = table_pricing.provider > AND > table_country.enabled = 1 > ORDER BY routeid > >what keys / indexes should I create on whatever tables to make this query >efficient? >I don't know if this query can be re-written even with JOINs and stuff. > >Please advise, > >If you've got an online doc. about that it will help too. > > >Elias > > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php