how to index this table with over 2 mill entries?
| From: | Andy | Date: | Sun, 31 Mar 2002 14:20:53 +0000 |
| Subject: | how to index this table with over 2 mill entries? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18075@lists.php.net to get a copy of this message | ||
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