Re: View performance

From: Umar FArooq <umar.farooq_at_cressoft.com.pk>
Date: Fri, 29 May 1998 13:00:49 +0500
Message-ID: <356E6B31.B466DD52@cressoft.com.pk>

the execution plan and the parse tree are already built and stored and, thus, querying from a view saves the corresonding time if a SELCT stmt was issued.
Umar.

stegri_at_rocketmail.com wrote:

> Does anybody know if using views instead of tables affects
> performance?
> I've heard that view are in some way 'compiled' (although I don't
> understand
> what is there to be compiled) and are even more efficient than
> retriving
> columns as 'normal' select-stmts.
>
> /Stelios Grigoriadis
Received on Fri May 29 1998 - 03:00:49 CDT