Just in case you need some more information about how to fix your queries,
this walks you through some examples
http://hackmysql.com/case2
On Mon, Mar 22, 2010 at 10:00 AM, Nicholas Hart wrote:
> I am looking to analyze and speed up some of my queries by adding any
> necessary indexes. Is there
On Mar 23, 2010, at 11:50 AM, Daniel Convissor wrote:
> On Tue, Mar 23, 2010 at 11:12:57AM -0400, Rob Marscher wrote:
>>
>> I'm having trouble finding exactly where it says it.
> ...
>> If you run EXPLAIN, you'll see it only picks one index to use for each
>> table.
>
> That may be true for the
On Tue, Mar 23, 2010 at 11:12:57AM -0400, Rob Marscher wrote:
>
> I'm having trouble finding exactly where it says it.
...
> If you run EXPLAIN, you'll see it only picks one index to use for each
> table.
That may be true for the queries you ran. If that's the case, you don't
have enough rows
> > One caveat to this is that mysql will only use one index per table in
> > your query.
>
> I've never heard that before. Do you have a citation from the manual on
> MySQL's website, please?
It's thrown around through some of the links Rob mentioned, but it's true
and notorious issue with inde
On Mar 23, 2010, at 10:16 AM, Daniel Convissor wrote:
> On Mon, Mar 22, 2010 at 01:42:14PM -0400, Rob Marscher wrote:
>>
>> One caveat to this is that mysql will only use one index per table in
>> your query.
>
> I've never heard that before. Do you have a citation from the manual on
> MySQL's
On Mon, Mar 22, 2010 at 01:42:14PM -0400, Rob Marscher wrote:
>
> One caveat to this is that mysql will only use one index per table in
> your query.
I've never heard that before. Do you have a citation from the manual on
MySQL's website, please?
Thanks,
--Dan
--
T H E A N A L Y S I S
