Re: SQL View vs CTE

[Charles Wilt <charles.wilt@xxxxxxxxx>]

No.

A view has no effect on performance.

Charles

On Wed, Dec 1, 2021 at 2:25 PM Greg Wilburn <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

> I have a complex SQL statement that I'm going to use as a data source for
> a browser application.  In ACS Run SQL scripts it consistently takes about
> 22 seconds to run.  The statement contains a CTE followed by a join to the
> CTE.  The files involved have a large number of records.
>
> So I'm wondering if someone can tell me whether creating an SQL View in
> place of the CTE would yield any performance increase (I haven't spent much
> time looking at the Visual Explain in ACS).
> I'm thinking it wouldn't make much difference.
>
> TIA
> Greg
> [Logo]<https://www.totalbizfulfillment.com/>    Greg Wilburn
> Director of IT
> 301.895.3792 ext. 1231
> 301.895.3895 direct
> gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
> 1 Corporate Dr
> Grantsville, MD 21536
> www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com