Re: Benchmarking Oracle on 2-processor HyperSPARC

Mike O'Connor wrote:
>
> if one were doing queries like this, on the other hand:
>
> SELECT * FROM tblMy5GigTable WHERE
> myComplicatedFunction(intMyMagicCookie) = 23456 ;
>
> i can see the opportunity for parallelization.
>
> does this thinking make sense?

Sounds like you just descripted a TPC-A. When was the last time a company's MC application only had to scan your 5 gig table? Sure, some environments may be better, but is that the real question? Would you put your entire database on a single CPU system? Answer that question and I think you just got the answer to your question above.

-- 
Neil Greene				"Pinky, you make me worry.  You are too
Sr. Oracle DBA / Unix Administrator		close to being a poster child for 
SHL Systemhouse, Inc. - L.A.			cheese wiz," Brain
<URL:mailto:ngreene_at_laoc.SHL.com>