Re: Oracle views and indexes

From: Richard Armstrong <StateOArt_at_worldnet.att.net>
Date: Wed, 2 Jun 1999 12:03:05 -0600
Message-ID: <7j3rfu$1f8$1@bgtnsc02.worldnet.att.net>

You need to do some explain plans on the statements to see where the indexes are needed for the cost based optimizer. You can set your session to rule based, but that is not the correct solution. I don't know why your application would require a major rewrite due to the optimization method. Optimization method is a function of the database, not the application.

It sounds like you need a tool to perform tuning analysis on your statements (such as SQL*Navigator/Tuner). You also need to get a tuning book such as Tuning Oracle from Oracle Press.

Your problem could be with an incorrectly tuned Oracle installation, or with poorly selected indexes.

--

---

Richard Armstrong
State Of The Art Consulting, Inc.
http://www.stateoart.com

---

John David Birch <john.birch_at_usa.net> wrote in message news:7j38ca$79h$1_at_romeo.dax.net...
> I have an application written i Power Builder 6.5.
> Complicated Queries involving views and outer joins permeate the
> application.
>
> The application can be used against a variety of DBMS's but runs into
> performance problems when run against Oracle. Oracle 7.3 and Oracle 8.0
seem
> to be about 75 times slower than Sybase ASA. Where as Oracle 8i improves
the
> situation by a factor of 3 but still lags behind ASA by a factor of 25.
>
> While the queries could be improved to make use of rule-based-optimizer
this
> would involve a major rewrite of the application.
>
> I would prefer to do something in the database such as define the view to
> make use of an index.
>
> Does anyone have any ideas as to how this might be achieved ? Or have any
> suggestions on how else I might tweek the database ?
>
>
Received on Wed Jun 02 1999 - 13:03:05 CDT