Re: Performance with synonyms???

Douglas Scott wrote:

> 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

There may be performance problem if you use functions (in packages) of other schemas in your views.
As a workaround you have to use a public synonym to reduce parsing time - Bug no. is 625806.
We experienced it in 7.3. and in 8.0.6.0 (and in 8.1.6 for NT although they say it is fixed in 8.1.3).

Bye
Volker Received on Wed Aug 09 2000 - 00:00:00 CDT