Re: Oracle's Myth: keep tables and indexes in separate tablespaces

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 10 Oct 2003 08:43:50 +1000
Message-Id: <3f85e533$0$28120$afc38c87@news.optusnet.com.au>

Noons wrote:

> "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
> news:3f858a85$0$28118$afc38c87_at_news.optusnet.com.au...
>

>>
>> Though I will go one step further, though it's only a logical conclusion
>> from what's already been discussed: one should be very careful about
>> making statements about what Oracle recommends or what its 'position' on
>> something is. Because the right hand quite frequently doesn't agree with
>> what the left hand has been writing.
>>

>
> Which reminded me of something:
> Do you know of ANY documentary evidence
> FROM Oracle about public synonyms being
> considerably heavier on performance than
> private ones or none?
> I just had a minor argument at work about
> precisely this and need to find something
> "heavier" than SA's site...
>

Having looked about a year ago for exactly that, I think you are out of luck. It's the kind of detail no-one at Oracle would have the time or inclination to test to get a definitive answer on.

Regards
HJR

-- 
--------------------------------------------
See my brand new website, soon to be full of 
new articles: www.dizwell.com.
Nothing much there yet, but give it time!!
--------------------------------------------

Received on Thu Oct 09 2003 - 17:43:50 CDT