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