[PHP-DB] how to index this table with over 2 mill entries?

[Andy]

Hi there,

I would like to optimize querrys on a huge table over 2 mio entries with
following structure:

ID mediumint(9) auto_increment
city varchar(50)
country_code char(2)
province_id char(2)

There is a need to do querrys on:
    city
    country_code
    country_code AND province_id

I already put a 10 char index on city this boosted up the table to 89 MB

Now I am wondering how to do the index on country and province. A index on
both, or 2 indexes. One for each.

Thanx for any advice.

Regards, Andy





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php