List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:September 27 2001 1:57pm
Subject:Re: Hi all,
View as plain text  
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

Thread
Hi all,Dan Liu27 Sep
  • Re: Hi all,Gerald Clark27 Sep
    • Add new usersmurugeswari Dharmarajan27 Sep
  • Re: Hi all,Benjamin Pflugmann27 Sep
  • Re: How to analyze and speed up this join queryArjen G. Lentz28 Sep