Re: Intermedia Text - Performance degradation over time

In article <32b8a689.0405200438.21b23ab5_at_posting.google.com>, grjohnson says...

>
> You'll also get fragmentation using dbms_jobs SYNC also if you are
> indexing on the fly as mentioned by Jeremy. Therefore, as well as
> SYNCRONISEing the index you must OPTIMISE the index to remove this
> fragmentation.
>

One other thing (and this is all with respect to 9i as we are moving up to this now) - is this non-blocking so that DML can be performed at the same time?

-- 

jeremy