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 -> Re: index tuning wizard

Re: index tuning wizard

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 29 Aug 2003 08:47:24 -0700
Message-ID: <3722db.0308290747.53f37f89@posting.google.com>


The index tuning wizard comes with the Enterprise Manager. If you don't know anything about it, read the manual on tahiti.oracle.com.

Daniel

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?
Received on Fri Aug 29 2003 - 10:47:24 CDT

Original text of this message

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