lists.mysql.com
> Subject: Re: Fwd: Query take too long time - please help!
>
> On 10.07.2012 13:16, Darek Maciera wrote:
> > 2012/7/10 Ananda Kumar :
> >> can u show the explain plan for your query
> >>
> >
> > Thanks, for reply!
> >
> >
On 10.07.2012 13:16, Darek Maciera wrote:
2012/7/10 Ananda Kumar :
can u show the explain plan for your query
Thanks, for reply!
Sure:
mysql> EXPLAIN SELECT * FROM books WHERE LOWER(ksd)=LOWER('4204661375');
That's definitely not the query you showed the first time around. The
query you'
2012/7/10 Ananda Kumar :
> can u show the explain plan for your query
>
Thanks, for reply!
Sure:
mysql> EXPLAIN SELECT * FROM books WHERE LOWER(ksd)=LOWER('4204661375');
++-+-+--+---+--+-+--++-+
| id | se
