Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> What is faster: Synonyms or Qualified names?

What is faster: Synonyms or Qualified names?

From: NNOOR <Nnoor_at_cris.com>
Date: 1997/05/25
Message-ID: <5m9neg$508@chronicle.concentric.net>#1/1 








I have PUBLIC synonyms defines for almost all of the object in a 
schema so they can be seen even when their name is fully qualified
in a query. I was wondering if the overhead of Oracle looking up
names in the PUBLIC schema has significant impact on performance?
Or it doesn't matter?



Thanks.



Nasir (nnoor_at_cris.com)
Received on Sun May 25 1997 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US