Re: Suggestions for first exam ...

On Sat, 27 Sep 2003 10:32:31 +1000, "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote:

>
>There really is a lot of either (a) nonsense or (b) loose talk made about
>indexes.
>
>You do *not* need to rebuild an index to 'get the tree ... balanced',
>because Oracle's indexes are *always* balanced. In real time, every time.

Sure, adding extra levels, that is.

A recent rebuild freed up 5 (FIVE) G of space, on a server, where space is at premium, and no extra disks can be added. So, what should we have done? Reading your comments, and never rebuild anymore? Try to convince a customer to replace a server? And just for the record: the application involved was Oracle Financials, where due to the nature of the application the majority of the indexes skew.
I'm not sure whether you really can judge the situation everyone is in. Yet you seem to pretend you can. I would rather suggest you would stop making such absolute comments, which in our situation don't make sense at all. We *HAVE* to rebuild indexes. PERIOD.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Sep 27 2003 - 02:08:08 CDT