Re: SQL View based on another View

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