Re: [PHP] help with making appropriate indexes.

On Friday 16 August 2002 18:05, lallous wrote: > But i'm not satisfied with your answer. This is not the appropriate list for your question in the first place. > I instinctly created indexes on > every field that I'm using w/ conditions. > But I feel that my script can be rewritten more effici

Re: [PHP] help with making appropriate indexes.

Thanks Miles. But i'm not satisfied with your answer. I instinctly created indexes on every field that I'm using w/ conditions. But I feel that my script can be rewritten more efficiently using JOINTs or other things. Any site with reading material regarding how to index and make complex queries

Re: [PHP] help with making appropriate indexes.

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.

[PHP] help with making appropriate indexes.

give this query: SELECT table_routing.id AS routeid, table_pricing.units AS price, table_routing.providerAS providerid, table_country.nameAS countryname, table_country.id AS country