Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> index tuning wizard

index tuning wizard

From: Christoph Kukulies <kuku_at_accms33.physik.rwth-aachen.de>
Date: 29 Aug 2003 10:54:25 GMT
Message-ID: <binbd1$4v8$1@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
Received on Fri Aug 29 2003 - 05:54:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US