Without seeing the data I am assuming that you are going over the 30% threshold with your less/greater equal to where clauses. What sort of criteria are you asking the database engine to search for?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/25/04, 9:44:02 PM, <[EMAIL PROTECTED]> wrote regarding Re: Query optimization help: > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]