Re: full text search on only some rows in the table?

From: Ron <support_at_dbainfopower.com>
Date: Sun, 8 Feb 2004 10:22:09 -0800
Message-ID: <aJidnbWQ-OlJ4bvd4p2dnA@comcast.com>

Hello Pascal,

Simplest would be to split tables into one indexed for search and another which is not.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"Pascal Damian" <pascaldamian_at_icqmail.com> wrote in message news:6bd4a4d3.0402080317.5e86c265_at_posting.google.com...
> Suppose a table stores 100k documents in a CLOB field. But I only
> wants to full-text index about 10k of those (to keep the search fast,
> and the 90k documents is not of interest for searching). How should I
> do that?
Received on Sun Feb 08 2004 - 12:22:09 CST