Re: SQL View vs CTE -- MIDRANGE-L

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.

Subject: Re: SQL View vs CTE
From: John Yeung <gallium.arsenide@xxxxxxxxx>
Date: Wed, 1 Dec 2021 22:55:11 -0500
List-archive: <https://archive.midrange.com/midrange-l/>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

On Wed, Dec 1, 2021 at 5:36 PM Timothy P Clark <timclark@xxxxxxxxxx> wrote:

The answer is a solid "maybe"... Without knowing more
details about the query and seeing the VE, it's impossible to say for sure
whether a view would improve performance, but it is worth a try.

I cannot emphasize enough: It is worth a try.

Almost anything is worth a try. And if you want to *know* whether
something is faster or not, the *only* way to truly acquire that
knowledge is to try it.

Even *with* all the details and seeing the VE, there is no substitute
for actually trying it and timing it.

John Y.

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.