Re: index not being pick up

[Øystein Grøvlen]

Hi,

It is the presence of an OR expression that causes the optimizer to not use the index. You could try to split the OR expression using a UNION query, but then the view would probably not be merged, but instead stored in a temporary table which could potentially be very large.

For the given query, I think the best would be to reverse the column of the index. That is, create an index on (reference, scope_id).

Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway