Synonym Performance

From: <billmil_at_my-deja.com>
Date: 2000/03/24
Message-ID: <8bgjbp$gle$1@nnrp1.deja.com>#1/1

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