Добрый день!

Есть запрос:

select SQL_CACHE match(event_index) AGAINST ('test' IN BOOLEAN MODE) as relevant, event_index like '%test%' as likesearch ,event.*,area.*,cat.* from eventinx_search search,eventinx_event event, eventinx_areas area, eventinx_categories cat where area.area_id=event.event_area and cat.cat_id=event.event_category and search.event_id=event.event_id having likesearch or relevant>0 order by area_id,cat_id,event_date

Можно ли его оптимизировать, если учесть что на поле event_index стоит fulltext....


Small Devil