index problem

2011-07-28 Thread xucheng
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`

Re: index problem

2011-07-28 Thread xucheng
. 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 xuch...@sankuai.com To: mysql@lists.mysql.com Sent: Thursday, 28 July, 2011 2:50:46 PM Subject: index problem Hi