Posts Tagged ‘public synonyms’
Poor performance using public synonyms
February 3rd, 2009 No Comments Posted in DBA Thoughts
I have heard the argument that says don’t use public synonyms if you have a large user base.
Public Synonyms are a good thing for most of us, they are not evil. I use public synonyms, but I do not over use them. Use them when you need them, but don’t make a public synonyms for every darn object in your schema.
It is generally a good idea to try an interact with your tables via packages. End users do not need to see the tables much of the time, especially in an OLTP environment. Public synonyms may still be used, but in most cases you will just want to use the package to do your work.
Even the database makes use of public synonyms when access many of your SYS packages. Like all things moderation is a good idea.
