Re: Are indexes owned by sys and system need to be rebuilt?

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 30 Jun 2001 19:04:36 -0700
Message-ID: <3B3E8533.6F1F7E87@exesolutions.com>

Julie wrote:

> Are indexes owned by sys and system need to be monitor (analyze) and rebult if
> needed? What's the cautious steps and impacts on performance?
>
> Thanks.

Is there a problem with them?

No index should be rebuilt unless there is a compelling reason.

But in general if they required rebuilding it would be no different from rebuilding any other index.

Daniel A. Morgan Received on Sat Jun 30 2001 - 21:04:36 CDT

This message: [ Message body ]
Next message: Rob K: "dbms_mview.refresh question"
Previous message: Julie: "Are indexes owned by sys and system need to be rebuilt?"
In reply to: Julie: "Are indexes owned by sys and system need to be rebuilt?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US