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: Synonym Performance

Re: Synonym Performance

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/03/24
Message-ID: <953931299.22693.6.pluto.d4ee154e@news.demon.nl>#1/1

No,

The parser tries to resolve the object name in the following sequence:

current user
private synonym
public synonym

Public synonym should be SLIGHTLY slower.

Regards,

Sybrand Bakker, Oracle DBA

<billmil_at_my-deja.com> wrote in message news:8bgjbp$gle$1_at_nnrp1.deja.com...
> How much overhead do you incur by using a public synonym to access a table
> outside your schema? E.g., for user LINUSER, instead of this statement:
> SELECT * FROM LIN.TOPICS; using: SELECT * FROM TOPICS; (where TOPICS is a
> public synonym which points to LIN.TOPICS;) I would guess the public
 synonym
> incurs minimal overhead, but perhaps "built for speed" applications might
> avoid them due to the drag on the system. Any thoughts? thanks bill
 milbratz
> chicago il usa
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Mar 24 2000 - 00:00:00 CST

Original text of this message

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