Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle's Myth: keep tables and indexes in separate tablespaces
"Noons" <wizofoz2k_at_yahoo.com.au.nospam> wrote in message news:<3f859f62$0$14559$afc38c87_at_news.optusnet.com.au>...
> "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...
If anything, there is an opposite recommendation. See note 131272.1
on Metalink.
They state that prefixing (no synonyms) is the best approach (from
tuning point of view), public synonyms is the next best and private
synonyms is the worst possible approach.
Received on Fri Oct 10 2003 - 10:07:40 CDT