Re: index tuning wizard

From: Svend Jensen <svend.s.jensen_at_it.dk>
Date: Sun, 31 Aug 2003 11:46:24 +0200
Message-ID: <3f51c3da$0$32448$edfadb0f@dread16.news.tele.dk>

Christoph Kukulies wrote:

> 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
Possible errors are:
1) Gupta is performing full scan of table(s), because of hints or other configuration issues.
2) Hauling large ammount of data to client for sorting/group by/.... check the setting on client cache,...

/Svend Received on Sun Aug 31 2003 - 04:46:24 CDT