-------------- SELECT version() -------------- +-------------------------+ | version() | +-------------------------+ | 5.0.45-community-nt-log | +-------------------------+ 1 row in set (0.00 sec) -------------- ALTER TABLE tblGeoStateCA ADD INDEX (frequency_assigned), ADD INDEX (call_sign), ADD INDEX (radio_service_code), ADD INDEX (class_station_code), ADD INDEX (location_county), ADD INDEX (location_city), ADD INDEX (location_address), ADD INDEX (entity_name), ADD INDEX (control_county) -------------- Query OK, 1540538 rows affected (20 min 38.45 sec) Records: 1540538 Duplicates: 0 Warnings: 0 Bye