Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Performance with synonyms???
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