Re: Tablespace Offline on Oracle 817i

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Fri, 02 Jul 2004 00:17:27 GMT
Message-ID: <pan.2004.07.02.00.17.27.11832@sbcglobal.net>

On Fri, 02 Jul 2004 00:09:08 +0000, Mladen Gogala wrote:

> Consequently, the best
> way to resolve the performance problem with a big join is to take all
> the tablespaces, containing tables being joined , offline. That will
> drastically improve the performance.

To honor esteemed colleague who wrote the book called "Optimizing Oracle for Performance" and, in his book, has discussed method "C" and method "R", I'd like to call this method "method N".

-- 
Well-behaved women seldom make history

Received on Thu Jul 01 2004 - 19:17:27 CDT