I'm trying to decide which index to use content or ctxcat, i'm new to Oracle Text, and from the documentation in the Application Developer's Guide, i'm having trouble deciding which index is the right one.

The concept is that the application this will be used on is to display a manual online. The manual is split into chapters and paragraphs. The chapters table has ID, NAME, CHAPTER_NUMBER columns; the paragraphs table contains an ID, NAME, TEXT, CHAPTER_NUMBER, PARAGRAPH_NUMBER.

The only fields that need to be indexed are the CHAPTER - NAME (VARCHAR2) and the PARAGRAPH - TEXT (CLOB).

Now i don't expect that any paragraph would exceed say 1MB. But the paragraphs could have inserts, updates, deletes fairly frequently.

So the auto synchornizing of the ctxcat looks appealing, but i'd like to see more information or examples on what type of data best suits each index type.

any help is appreciated.