-
Senior Member
SQL Clusterered Index... what to use?
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|