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

Home -> Community -> Usenet -> c.d.o.server -> Performance with synonyms???

Performance with synonyms???

From: Douglas Scott <dsscott_at_ev1.net>
Date: 2000/08/01
Message-ID: <39874106.AC25C9F8@ev1.net>#1/1

Is there a performance hit if you use all public synonyms for a schema's objects vs fully qualifying the schema's object? Example: if I want to query from the emp table in the scott schema is it better to select from scott.emp or just emp where there is a public synonym defined as scott.emp. I was told there was back in the old days (Oracle version 5).

Douglas Scott Received on Tue Aug 01 2000 - 00:00:00 CDT

Original text of this message

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