SQL Clusterered Index... what to use?

[Dricciotti]

Hey all,
I am starting a large database using mySQL and I have been spending a lot of time on the table and structure... making sure that everything is thought about correctly. The main table (called 'maintable') holds information about a location; such as latitude, longitude, name, description, 2-3 other meta fields, and a unique ID number. I need to choose which one to use as the clustered index.

My thoughts:
Most queries will be geo-based queries (for example: select all rows with a lat/lon between a specific range).
Other queries will be for the ID number.

Should I consider using the latitude column as the clustered index? It would help reduce the query time, but still have to do the longitude part of the query.

Thanks for any input!
danny

[Dricciotti]

anyone?