Re: index problem

should pick up the index. > > Index hints are rarely ever needed. It's best to stay away from them unless > you know exactly what's going on under the hood :-) > > > - Original Message - >> From: "xucheng" >> To: mysql@lists.mysql.com >>

index problem

Hi i found a strange problem . when i using index for 'select' , i got a slower result than without index . i have a tabe : create table geo_query ( `id` int(10) unsigned not null auto_increment , `start` bigint(20) unsigned not null , `end` bigint