Searching .. Re: [thesite] meta description

[Dean Mah]

I have installed IMT and have indexed the BODY column of the CONTENT
table.  Building the index took about a minute and a half.  It'll
probably be shorter to re-index since the entire thing will not be
re-created.  You can also create indexes online so the table can be
queried while index building is taking place.

We can set up a trigger or a stored proc. to do the re-indexing.

Take a look at:

   http://www.orafaq.org/faqctx.htm
   http://desktop.msfc.nasa.gov/oracle815doc/inter.815/a67843/toc.htm

Dean


.jeff writes:

> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > From: Dean Mah
> >
> > 1) We need to install interMedia Text and index the
> >    content.
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> 
> can we get that column indexed now so i can start fooling around with the
> search functionality?
> 
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > 2) We also need to trigger a re-index when new data is
> >    added or updated and/or schedule periodic re-indexing
> >    of the table.
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> 
> can we set this up as a trigger when the content column is updated?  or,
> perhaps we can set it up as a stored procedure i can call from coldfusion
> whenever the content is updated.
> 
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > 3) We need to change or add a CONTAINS clause to the
> >    search queries.
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> 
> do you have any links handy that show how to use the CONTAINS clause?