Re: Oracle 8.1.6.0.0 performance boost options

From: Mark Tompkins <mdtompkins_at_home.com>
Date: Thu, 24 May 2001 17:49:14 +0100
Message-ID: <3B0D3B89.A97F68A4@home.com>

Yes,

We are using hints. The project has a colorful history, to say the least. Hints have come and gone, and come again.

Thomas Niering wrote:

> Hallo Mark,
>
> > We have performance problems, with queries that are not using
> > indexes, sometimes because they access views, and indexes are not
> > used (tempdb). The temp db access appears to overload the cpu.
>
> Have you tried to optimize your queries by using hints?
>
> Ciao Thomas
Received on Thu May 24 2001 - 11:49:14 CDT