Dennis, I think it was actually Steve Adams that did some work on the evil of synonyms and public vs. private, a while ago. You can still see his findings at http://www.ixora.com.au/, click the "Newsletter" = tab, and look for a link titled 'Sinonyms', and yes, I'm pretty sure it's=20 spelled that way. -Mark > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of DENNIS WILLIAMS > Sent: Tuesday, November 02, 2004 11:58 AM > To: nsouto@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx > Subject: RE: Avoid a synonym <stuff deleted> > 3. As I recall, it was Jonathan Lewis who mentioned that=20 > public synonyms > could cause performance problems, and I have passed that=20 > along to my boss. <lots of stuff deleted> -- //www.freelists.org/webpage/oracle-l