Oracle views and indexes

From: John David Birch <john.birch_at_usa.net>
Date: Wed, 2 Jun 1999 14:36:11 +0200
Message-ID: <7j38ca$79h$1@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 - 07:36:11 CDT