Maybe i'm wrong here, someone correct me, if its just int's you are gonna use set the field types to bigint it may search faster you are doing a character search, to get there quicker in a text search scenerio i'd suggest mysql4 and full text searching MATCH AGAINST
> I've got a query that I can't seem to get optimized, so I'm > hoping someone here can spot something I've missing! > > Table has three columns: > CoordID int unsigned, > Zip_Lo char(9), > Zip_Hi char(9) > > Table has 3 million records > > indexes: > acg_lo (Zip_Lo) > acg_hi (Zip_Hi) > acg_combined (Zip_Lo, Zip_Hi) > > ------------------------ > > Here's the query: > > select * from acg > where zip4_lo_pot <= '801281111' and > zip4_hi_pot >= '801281111' > > ------------------------ > > Explain shows: > > type: ALL > possible keys: acg_lo,acg_hi,acg_combined > rows: 3022309 > extra: Using where > > > So, how can I optimize this? > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
