Re: Index not used therefore rebuild the thing ...

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3fb9f76c$0$263$ed9e5944_at_reading.news.pipex.net...
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:SV3ub.14720$aT.9988_at_news-server.bigpond.net.au...
> > There's a recent post on the Metalink Oracle Server forum (Index columns
> > with Null-values), where someone complained that their index was not
being
> > used during a join and a FTS was being adopted instead. The index
contains
> > nulls and wondered if this could be an issue. This was all the info
> supplied
> > by the poster.
> >
> > The reply from Oracle, rebuild the index in case the index is fragmented
> or
> > the statistics are out of date.
> >
> > What the *%#@ !!
> >
> > I made what I hope is considered a "constructive" reply but I feeling
like
> > I'm fighting a losing battle against an army of Orcs.
>
> It was a very constructive reply, though you missed out that the poor guy
> from Oracle didn't know what type of index it was either :( What actually
> amazed me was that the support guy referenced note 67522.1 which has
nearly
> all the questions you asked, and *still* jumped straight to rebuilding. It
> made me wonder whether he had actually read the support note at all.
> Actually a response along the lines of please refer to 67522.1 would have
> been fine.

Hi Niall,

Ah, pleased to hear it was at least deemed constructive by some ;) The list I'm sure could easily be doubled but I felt I made my point.

Hopefully, future responses will be a little less flippant and more considered (or indeed more accurate).

>
> > Are there any Elves out there or are the forces of evil really taking
over
> ?
>
> There are some excellent people in Oracle support if my recent experience
is
> anything to go by. Those days it is as effective as the English rugby
team.
> Other times it is effective as the English cricket team :(
>

Yes, I agree there are some excellent support people.

I'm sorry Niall, I've never heard of Rugby. I don't think we Australians take it at all seriously ....

Cheers ;)

Richard Received on Sat Nov 22 2003 - 07:09:43 CST