Re: Query Optimization

Suggestions are much appreciated. The last two of which both worked quite well - especially after convincing the client DBA to move on the indexes.

Having no understanding of my market, offering NO solution and feeling compelled to dictate what is and is not good policy - a complete waste of time.

On Feb 26, 8:21 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Roy wrote:
> > We do not do non-billable, in-house improvements (matter of policy -
> > yes, even for something as easy as adding an index). I'm a BA on a
> > customer site who has lost his Oracle guru to the military. I don't
> > have the immediate budget to grab a contractor so... I'm temporarily
> > up the proverbial creek, sans paddle.
>
> > The goal here is to mine potential data for a new interface I'm
> > designing. Now - what would a script look like that adds the indexes
> > (or temp tables?), performs the query, and then drops the temporary
> > elements?
>
> > -rgb
>
> > On Feb 26, 4:54 pm, DA Morgan <damor..._at_psoug.org> wrote:
> >> Roy wrote:
> >>> Also - for whatever the reasons, indexing is not an option (per my
> >>> developers)
> >> Please explain this. If "my developers" ever said this to me my first
> >> reaction would be to ask them to work on their resumes.
> >> --
> >> Daniel A. Morgan
> >> University of Washington
> >> damor..._at_x.washington.edu
> >> (replace x with u to respond)
> >> Puget Sound Oracle Users Groupwww.psoug.org
>
> Good recommendations from Charles and AlterEgo ... but without the
> ability to build an index ... it sounds like the "policy" is rather
> expensive ... unless you are donating your time.
>
> A policy that costs more than the alternative is a bad policy.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Received on Mon Feb 26 2007 - 23:07:58 CST