Re: Synonym Performance

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