MySQL Forums
Forum List  »  Full-Text Search

Re: Full-text search of exact phrase problem
Posted by: Anton Staykov
Date: October 29, 2007 04:19AM

Hi Lucas,
The non-normalized column is an option. But I think you should firstly check the performance and then adding that additional column. Before all the HAVING clause is applied after the result is filtered by the FULL-TEXT matches so if the FULL-TEXT does not return a bunch of rows, may be the impact of HAVING clause will no be that bad.

cheers,

Options: ReplyQuote


Subject
Views
Written By
Posted
12554
October 11, 2007 03:35PM
Re: Full-text search of exact phrase problem
5169
October 29, 2007 04:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.