[Q]Any diff using Synonym vice Fully Qualified table Name?

From: Phil Melendez <pme_at_crash.cts.com>
Date: 1995/04/30
Message-ID: <D7tzLD.I0L_at_crash.cts.com>#1/1


To All,

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


Thanks,

Phil Melendez Received on Sun Apr 30 1995 - 00:00:00 CEST

Original text of this message