Re: Any diff using Synony

From: FRANK NAUDE <frank.naude_at_onwe.co.za>
Date: 1995/05/07
Message-ID: <8A8E4AA.0BBB000E57.uuout_at_onwe.co.za>#1/1


In article <D7tzLD.I0L#crash.cts.com> pme_at_crash.cts.com (Phil Melendez) write:

>Is there any difference in performance when using synonyms vice the fully
>qualified table name? Example:
>
> select emp_name, emp_code
> from emp
> where emp_name = 'John'
>
> select emp_name, emp_code
> from misc.emp <--
> where emp_name = 'John'

Our PC-Lab guys told me that Oracle Forms 4.5 prefix object names with the current schema (ie SCHEMA.TABLE). They don't like it since it makes the application static/unportable (they can't move it to a different schema). So they need to revise _all_ generated triggers and edit it out!

Any ideas on how to avoid this?

Cheers
Frank Received on Sun May 07 1995 - 00:00:00 CEST

Original text of this message