"Christoph Kukulies" <kuku_at_accms33.physik.rwth-aachen.de> wrote in message
news:binbd1$4v8$1_at_nets3.rz.RWTH-Aachen.DE...
> I have an installation (with Gupta/Oracle Gateway) which suffers
> from a big performance decrease when going to the Oracle (8i) DB
> though the gateway.
>
> Going directly to the SQL Windows DB a request on an INDEX performs in
> 0.3 seconds. Doing the same on the Oracle DB it lasts 300 seconds.
>
> A colleague mentioned an Index Tuning Wizard. Could that help? Where
> can I find it?
>
> --
> Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de
Get the explain plan and tkprof of the query and post it. It would help
figure out what is going on. Have you analyzed your tables and indexes in
Oracle?
Jim
Received on Fri Aug 29 2003 - 06:02:03 CDT
