Hi,

We are using FullTextSearch in one of our table columns. A Context index is created for this purpose.

CREATE INDEX CONTENT_idx ON TEMPLATE (CONTENT) INDEXTYPE IS CTXSYS.CONTEXT;

These kind of indexes are not transactional. So we need to synchronize them whenever a new data is inserted/updated into the table. Also we need to optimize this index on daily basis to improve the performance of the Queries.

Is there anyway to do this through LLBLGen? Or what is the better way to do this?

Better done by Triggers.

You can set up full index search in sql server at least in such a way that it updates the catalog automatically (it's a setting when you setup full index search). We use that too on this forum.

I now see you're using Oracle, not sql server, my bad. My previous reply is of no use to you, indeed use triggers in this case, and check whether oracle's full text search has build-in catalog build. If so, you could avoid triggers and use that.