Re: Speed hit of simple views...

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 12 Nov 2001 22:19:30 +0100
Message-ID: <d4f0vt40fv2shs67q7vhus9421bfbe68ai@4ax.com>

On Mon, 12 Nov 2001 18:37:22 +0100, Andreas Koch <mail_at_kochandreas.com> wrote:

>Hi,
>
>would abstracting the database access by just using a View:
>
>create view vTable as select * from Table;
>
>instead of the table cause considerable slowdowns?

No, not necessarily. However, please take note views are compiled, and your * will be resolved at compile time, not at run time. As soon as you add a column or alter a column, your view will become invalid and needs to be recompiled.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Nov 12 2001 - 15:19:30 CST