Re: Direct path write

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 18 Aug 2004 07:48:35 +0200
Message-ID: <6dr5i09fpsrve47tuejm7tn5jj07r112du@4ax.com>

On Tue, 17 Aug 2004 09:33:53 +1000, "Howard J. Rogers" <hjr_at_dizwell.com> wrote:

>Jaap W. van Dijk wrote:
>
>> On Mon, 16 Aug 2004 21:59:56 +1000, "Howard J. Rogers"
>> <hjr_at_dizwell.com> wrote:
>>
>> ...
>>>Try not rebuilding indexes at all, since they almost certainly don't need
>>>it.
>>>
>>>Regards
>>>HJR
>>
>> Maybe not in a transactional application.
>>
>> For bulk loads they can have been set to UNUSABLE.
>>
>> Jaap.
>
>Come on... I said "almost". Inevitably, there are circumstances where they
>must be rebuilt (alter table move, anyone?).
>
>Bulk loads are just one amongst many.
>
>The point was not to iterate all possibilities, but to get the OP to
>validate the real *need* to rebuild before going ahead and doing it.
>
>Regards
>HJR
>

The picture just struck me as funny: this guy having a bunch of unusable indexes and somebody advising him not to rebuild them at all. Clearly that was not what you had in mind.

Maybe we can agree on 'Try not rebuilding valid indexes at all, since they almost certainly don't need it'.

Jaap. Received on Wed Aug 18 2004 - 00:48:35 CDT