Re: Full-text search of exact phrase problem
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,
Subject
Views
Written By
Posted
12899
October 11, 2007 03:35PM
6294
October 25, 2007 06:44AM
5571
October 28, 2007 08:03AM
Re: Full-text search of exact phrase problem
5323
October 29, 2007 04:19AM
6534
October 30, 2007 12:25PM
5710
November 01, 2007 06:16AM
5139
November 03, 2007 03:03PM
4567
November 08, 2007 04:14AM
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.