Re: Synonyms

it depends, synonym is just like pointer. I had seen some of the dbas they discourage use of synonyms because it becomes overload when there are billions of rows in an object

yes synonyms can be either public or private and they are used for security of objects for which they are created.

Thanks!
Subodh
On 1 December 2010 06:01, Joshua D. Drake <jd_at_commandprompt.com> wrote:

> Hello,
>
> Kind of out of left field here but I was curious about how many people
> here use Synonyms and the types of synonyms they are normally using,
> i.e; table/view/column?
>
> Sincerely,
>
> Joshua D. Drake
> --
> PostgreSQL.org Major Contributor
> Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
> Consulting, Training, Support, Custom Development, Engineering
> http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================

--
http://www.freelists.org/webpage/oracle-l