Oracle-L: Re: Rebuilding Indexes...

From: Jared Still <jkstill_at_cybcon.com>
Date: Thu, 26 Dec 2002 19:13:43 -0800
Message-ID: <F001.00522C80.20021226191343@fatcity.com>

Though I have published a script for determining indexes that need to be rebuilt, and then rebuilding them, I have to say that this is almost never necessary.

Why are you rebuilding indexes? About the only reason for ever doing so is that the BLEVEL >= 5.

goto asktom.oracle.com, and do a search on 'index rebuild'.

Currently, the third article may be of interest.

Jared

On Thursday 26 December 2002 12:24, Richard Huntley wrote:
> Anyone have any useful scripts for doing this?
>
> TIA,
> Rich

Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: 7bit
Content-Description: 
----------------------------------------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Dec 26 2002 - 21:13:43 CST