Re: Query Optimization

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
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org