Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why PUBLIC SYNONYM is bad ?

Re: Why PUBLIC SYNONYM is bad ?

From: Yong Huang <yong321_at_yahoo.com>
Date: 16 Jun 2002 10:26:04 -0700
Message-ID: <b3cb12d6.0206160926.25dc8eea@posting.google.com>


Nuno Souto <nsouto_at_optushome.com.au.nospam> wrote in message news:<3d0bfd7e$0$28008$afc38c87_at_news.optusnet.com.au>...
>
> For some good text stuff on public synonyms and their performance impact,
> see Steve Adam's site: www.ixora.com.au
> There is a section on newsletters and IIRC the synonym stuff is in one of
> them.

It's here:
http://www.ixora.com.au/newsletter/2001_05.htm#synonyms

Steve shows that synonyms, particularly public synonyms, are indeed bad in terms of CPU usage. But he said at the beginning "the best way to refute such scepticism [i.e. synonyms are bad] is with a reproducible test", as if his following test would show otherwise.

Yong Huang Received on Sun Jun 16 2002 - 12:26:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US