Re: Performance Impact of SQL Views (was: SQL Statement length)

On Fri, May 13, 2016 at 11:09 AM, <dlclark@xxxxxxxxxxxxxxxx> wrote:

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 05/13/2016
09:15:42 AM:
Now, we may still be lacking in our understanding of what is going
on under the covers of SQL, however we are now shying away from creating
views willy-nilly as the spirit moves us. The reason is because we now
understand that a view has to be rendered at the time it is opened and
such rendering can have (and has had, in our case) a major performance
impact on the system.

Nothing beats actual measurement and empirical observation.

Reminds me of the famous Donald Knuth chestnut:

"Beware of bugs in the above code; I have only proved it correct, not tried it."

He's also the one with the famous warning about premature optimization.

John Y.