Rebuilding Blob Indexes - Is it necessary?

From: Mark Sherwood <checkfreedbguy_at_aol.com>
Date: Thu, 3 May 2001 11:22:44 -0400
Message-ID: <eKeI6.234145$Z2.2480207@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 - 10:22:44 CDT