Re: Direct path write

On Wed, 18 Aug 2004 16:07:18 +1000, "Howard J. Rogers" <hjr_at_dizwell.com> wrote:

>Jaap W. van Dijk wrote:
>
>> 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.
>
>Unless you'd care to postulate that I am a complete moron and know zilch
>about the Oracle RDBMS, it is highly unlikely that anything even remotely
>along those lines would be what I had in mind.
>
>Of course, I can't stop people reading what I write with a bloody-minded
>literalness that makes the words mean nonsense.
>
>But even if you insist on doing that, try reading ALL the words before
>parsing them. The 6-letter one "almost" has a significance in the sentence
>you apparently missed.
>
>> Maybe we can agree on 'Try not rebuilding valid indexes at all, since
>> they almost certainly don't need it'.
>>
>> Jaap.
>
>No we can't agree on that, because it would imply the readers here are
>morons too. Leave it at my original formulation, and trust to the innate
>intelligence and good sense of most DBAs to spot an exception to the
>general rule when it arises.
>
>HJR
>
>

Oh well, there's no bridging the gap then...

Still wonder what made your lid come flying off.

Jaap. Received on Thu Aug 19 2004 - 14:10:33 CDT