Index 2 is redundant.
What indexes do you have on s1?
Dan Liu wrote:
> Hi all,
> I am running a query on mysql.The query is simple.It retrieves 2800 rows and 250
> columns data.I created index for the query.But it still takes over a minute.
> The query is :
> select s1.p012 from geo,s1 where s1.log=geo.log and geo.lev=60 order by geo.sub;
> I have following index on geo:
> 1.index1(log,lev,sub);
> 2.index2(log,lev);
> 3.index3(lev);
>
> Could somebody tell me what should I do?And why it is so slow?
> Thanks!
> Dan
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread86503@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
gerald_clark@stripped
