Re: Synonyms
- From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
- To: jd@xxxxxxxxxxxxxxxxx
- Date: Thu, 2 Dec 2010 18:08:02 +0530
hi Jousha,
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@xxxxxxxxxxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
==============================
DO NOT FORGET TO SMILE TODAY
==============================
Other related posts:
