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
12579
October 11, 2007 03:35PM
6135
October 25, 2007 06:44AM
5416
October 28, 2007 08:03AM
Re: Full-text search of exact phrase problem
5182
October 29, 2007 04:19AM
6357
October 30, 2007 12:25PM
5520
November 01, 2007 06:16AM
4991
November 03, 2007 03:03PM
4418
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.