09-15-06, 05:02
|
|
Registered User
|
|
Join Date: Jul 2004
Posts: 62
|
|
Indexing against BETWEEN instead of =
|
|
Greetings all MySQL DBA,
I index my callno fields for fast search. When i did BETWEEN statement , it turned to slow down the query, and from the explain statement
Quote:
|
explain select * from raw where callnobetween 71016800690001 and 71016800690100
|
Quote:
id,select_type,table,type,possible_keys,key,key_le n,ref,rows,Extra
1,SIMPLE,raw,ALL,PRIMARY,,,,17478015,Using where
|
How do i improved my indexing.
Thank you
|
|
dBforums
>
Indexing against BETWEEN instead of =
Linear Mode
