Re: Any diff using Synony
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