On Mon, Nov 29, 2010 at 5:27 AM, AI Rumman wrote:
> Full Text index is not using during OR operation for multiple table join:
Hmm. If you have a condition of the form
OR
then the system is going to have to join those tables before
evaluating that condition. It can't scan A and throw awa
Full Text index is not using during OR operation for multiple table join:
explain
SELECT crmentity.crmid, crmentity.setype, crmentity.modifiedtime,
activity.subject,case when ( users.user_name not like '') then
users.user_name else groups.groupname end as user_name, activity.date_start
FROM crmenti
