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

From: Ron <support_at_dbainfopower.com>
Date: Mon, 9 Feb 2004 04:05:05 -0800
Message-ID: <eaednaIBMa9z6Lrd4p2dnA@comcast.com>

Hello Pascal,

For a small table suggested design would work.

Just make sure, that table would not be growing fast in this future - it would not scale very well.

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.0402082058.79541a13_at_posting.google.com...
> 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.
>
> --
> Pascal
Received on Mon Feb 09 2004 - 06:05:05 CST