Re: Rebuilding Blob Indexes - Is it necessary?

Perhaps I didn't explain this very well.

I am referring to the index that Oracle requires for the LOB Locators. I don't believe that I have any choice about its existence as long as I am using "Out of Row" LOB storage..

I have no choice about having
Steve Long <steven.long_at_erols.com> wrote in message news:9cs38t$55m$1_at_bob.news.rcn.net...
> if you have good logical keys i would expect an index on the blob is
> unnecessary.
>
> "Mark Sherwood" <checkfreedbguy_at_aol.com> wrote in message
> news:eKeI6.234145$Z2.2480207_at_nnrp1.uunet.ca...
> > We have a process that inserts and deletes many rows to a table that
> > includes a Blob column. For performance reasons, we "rebuild" the
 indexes
 on
> > the table from time to time to cleanup leaf pages.
> >
> > There does not appear to be a way to "rebuild" the Blob Index that
 Oracle
 is
> > maintaining.
> >
> > Does anyone know how to "rebuild" these indexes or if it is even
 necessary?
> > Are these indexes somehow different from typical Oracle Indexes, other
 than
> > being maintained by Oracle?
> >
> > ...Mark
> >
> >
>
>
Received on Thu May 03 2001 - 13:06:49 CDT