Re: Synonym or View?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 9 Dec 2000 18:40:01 +0100
Message-ID: <90tugd$2bka8$1@ID-62141.news.dfncis.de>

In this case the view is redundant as the view is an exact virtual copy of your table. Also view definitions are compiled so you need to recompile whenever the table changes. Finally it can happen the view is treated as a separate step in your query path.

With this reasons, which do you think is the correct answer?

Regards,

Sybrand Bakker, Oracle DBA

<david_petit_at_yahoo.com> wrote in message news:90tn9t$mde$1_at_nnrp1.deja.com...
> Hello all,
>
> I want to direct A_Alias to table A. Which one is better (just for
> select, no modification of table A)?
>
> 1) Built a public synonym from A_Alias to A
> 2) Built a view A_Alias that select * from A
>
> in terms of performance, security and easy for administration.
>
> THanks,
> David
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Dec 09 2000 - 11:40:01 CST