On 10 Feb 2005 12:53:58 -0800, linuxgeek_00_at_yahoo.com wrote:
>My company wants to implement a corportate wide public synonym model
>for our oracle 9i database. Meaning that every table in every schema
>would have a public synonym created against it. Personally I think
>this is a bad idea. However I need to develop a convincing arguement
>to change this policy that has been suggested by our "DBA's".
>
>One issue is that I'm aware of is that all table names must be unique
>across all schemas. Please let me know other reasons why it is a bad
>idea to create public synonyms for every table in every schema.
>
>Thanks
- slower parsing (public synonyms are evaluated last)
- there seem to be issues with statement sharing and public synonyms,
definitely when you refer to the object directly, and by means of
public synonym, this is treated as two non-identical statements.
--
Sybrand Bakker, Senior Oracle DBA
Received on Thu Feb 10 2005 - 15:18:58 CST
