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

sybrandb_at_yahoo.com wrote in message news:<a1d154f4.0311180043.8e265f3_at_posting.google.com>...
> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1069122693.821136_at_yasure>...
> > Joel Garry wrote:
> >
> > > Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in message news:<ha5irv0c7fvuldjp6dlh71u748bhbvfqai_at_4ax.com>...
> > >
> > >>On Mon, 17 Nov 2003 13:19:46 GMT, "Richard Foote"
> > >><richard.foote_at_bigpond.com> wrote:
> > >>
> > >>
> > >>>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.
> > >>>
> > >>>Are there any Elves out there or are the forces of evil really taking over ?
> > >>>
> > >>
> > >>No, Oracle must have fully staffed their support department with
> > >>people who are both OCP and only know how to navigate Metaclunk.
> > >>They have no real world experience other than reading the docs.
> > >>As opposed to the 90's when you could phone someone in your own
> > >>country, and the someone really knew something about Oracle.
> > >
> > >
> > > In the 90's I would wait until after 5PM to call to get switched over
> > > to the Australian group who really knew something!
> > >
> > >
> > >>
> > >>>BTW, any Aussies going to the Hotsos Tuning course with Cary Millsap this
> > >>>week. If so, catch ya there. Looking forward to spending some time with
> > >>>Elrond.
> > >>>
> > >>>Cheers ;)
> > >>>
> > >>>Richard
> > >>>
> > >>
> > >>So, Larry ends up as Saruman? (Where of course Bill is Sauron)
> > >
> > >
> > > Is that what that mysterious message from hotsos that went to my
> > > no-html address was all about?
> > >
> > > jg
> > > --
> > > @home.com is bogus.
> > > http://www.signonsandiego.com/news/uniontrib/fri/currents/news_1c14aust.html
> >
> > I second the thought. I too used to wait for the phones to be switched
> > to Australia to make support calls.
> >
> > I have had nothing but problems with calls switched to India. Whether
> > the people are or are not technically knowledgeable is not the issue.
> > Rather it is the fact that they are not screened for an ability to
> > communicate with non-Hindi speakers in English. It is becoming quite a
> > problem.
>
>
> So you did voice your concerns to Oracle?

Having the same experience, no, I just keep at it until I get a reasonable written response. But Oracle periodically revamps how it works anyways, whatever the feedback. I've had US-based support people tell me they don't like particular revamps, too.

> I have the feeling if it continues in this direction (and you only
> have to follow threads in the Metaclunck forums to verify quite often
> they are trying to put off customers), the state of support is going
> to kill Oracle.

I generally try to work out as much as I can before calling support. However (and we see it even on this group), the vast majority don't, even with published docs on "How to deal with support." So I think from O's point of view, it makes sense to have front-line support as cheap and voluminous as possible - anyone with a serious problem will make it past the frontline, since they have an emotional/financial investment in getting the problem solved.

It does vary quite a lot depending on the group you get. 9iAS on Windows is bound to get some young'un with communication issues. I've found installation/upgrade on unix usually gets me to capable people in Denver or some such pretty quick.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/uniontrib/sun/metro/news_1mi16ebay.html