Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: full text search on only some rows in the table?
Andy Hassall <andy_at_andyh.co.uk> wrote in message news:<9n0d20ljjebdg658ed4e7j9gbejhab6bi2_at_4ax.com>...
> Approaching it from the other direction, another possible approach could be to
> make the Text index a USER_DATASTORE index, based on a function that returns
> NULL for the docs you don't want indexed, and the actual content for those you
> do?
Yes, I think this is a nicer approach, because I don't want to ruin the design by splitting the table. Thanks for the hint.
-- PascalReceived on Sun Feb 08 2004 - 22:58:34 CST
![]() |
![]() |