The only difference is, that part of the parsing work (syntax and
semantic check) already happened. But that's no big performance gain.
regardsQuote:> 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.
Tom Lane wrote :
Thanks very much for this "fast as speed light" answer !
Is there an idea about the 7.1 release date ? Just to know if this is
will be in weeks, months or years...