Getting started Part 4 – Index maintenance

| Jul 30, 2014

This post follows on from Part 1Part 2 and Part 3 and uses the same example "quickstart" table.

One thing that often catches new users out is that Oracle Text CONTEXT indexes are not synchronous. That is, updates to the table are not immediately reflected in the index. Instead, the index must be synchronized. We can do this manually with a call to CTX_DLL.SYNC_INDEX, or we can arrange to have it done (more...)

Getting started Part 3 – Customizing indexes

| Jul 30, 2014

This post follows on from Part 1 and Part 2 and uses the same example "quickstart" table.

So far we've looked at queries run against a default CONTEXT index, which you'll recall we created with the statement:

create index full_name_index on quickstart( full_name ) indextype is ctxsys.context;

CONTEXT indexes have many options available. We can't possibly cover them all here, but instead we'll look at the mechanism for applying customization to an index. This (more...)