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
