Oracle Search, Just Rebuild the Index

June 1, 2010

Yep, big flows of unstructured content. Stuff the information into Oracle. Index. What could go wrong? To get some insight, navigate to “Using Oracle to Search Text Documents”. For me the most interesting comment in the write up is:

Also, remember to rebuild the index every time you add docs to the table.

Yep, job security for an Oracle database administrator. As the tables get larger and content flows go up, big money to deal with performance associated with real time index rebuilding.Wow. Every time I add a document!

Stephen E Arnold, June 1, 2010

Freebie

Comments

Comments are closed.

  • Archives

  • Recent Posts

  • Meta