6.7 Using Synonyms

---

A synonym is, as its name implies, another name for a known object. Synonyms are typically used to reference tables between schemas. Public synonyms make tables contained within schemas available to all schemas. Apart from the obvious security issues there can be potential performance problems when over-using synonyms in highly concurrent environments. It may not necessarily be effective to divide functionality between different schemas only to allow users global or semi-global access to all of the underlying schemas. Simplicity in development using objects like synonyms often leads to complexity and performance problems in production. Additionally too many metadata objects can cause problems with the shared pool.

---