Re: SQL View based on another View

[Charles Wilt <charles.wilt@xxxxxxxxx>]

IBM considers a view "performance neutral".

They neither improve or hurt performance.  (And if you ever hit a case were
they are not, a PMR would  be in order)

If the SQE has to re-optimize, I suppose there must be a small hit while it
looks up the SQL statement in the view.  But that would be pretty
insignificant.

Charles



On Fri, Sep 16, 2022 at 2:55 PM Alan Cassidy <cfuture@xxxxxxxxxxx> wrote:

> Is there anything I should know before doing this? I have created a
> /very/ complex View for a certain application that needs a little more
> "complication".
>
> Running a View with the primary driver FROM file being itself a View,
> does that add any significant performance hit as opposed to
> incorporating these added clauses into the code of the first View?
>
> I know "it depends", but what would be the considerations is what I'm
> asking.
>
> ---Alan Cassidy
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-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