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