Re: Are selects defined in view faster than run-time selects?

If you see a view as a stored SELECT-statement with a name, without any physical representation...then there's no reason for a view to be faster.

The only difference is, that part of the parsing work (syntax and semantic check) already happened. But that's no big performance gain.

On Sun, 07 Apr 2002 10:21:11 +0100, Dragan Matic <gekko_at_eunet.yu> wrote:

> Are selects that are defined as views faster than normal selects? I
>am asking this because I have a big select where I retrieve data from
>multiple tables. Is such a select going to work faster if it is defined
>as a wiew. I found nowhere in literature that views are speeding up
>selects but I recently heard such an opinion.
>

regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Sun Apr 07 2002 - 15:00:38 CEST