Re: Rebuilding Blob Indexes - Is it necessary?

From: Steve Long <steven.long_at_erols.com>
Date: Thu, 3 May 2001 13:04:51 -0400
Message-ID: <9cs38t$55m$1@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 - 12:04:51 CDT