Re: SQL Views worth it?

[Alan Campin <alan0307d@xxxxxxxxx>]

Have you ran a Visual Explain over your query that is using the view? You
might be running a table scan or something else to slow down query. Might
need an index created. Without running Visual Explain pretty hard to know.

On Fri, Aug 24, 2018 at 12:04 PM Greg Wilburn <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

> My limited experience with SQL views (and views within views) for
> reporting is that they are invaluable.  You also have tools (index advisor)
> that can improve performance dramatically.  Running tools like DB2 WebQuery
> and others would have been nearly impossible with our legacy database,
> without using SQL views.
>
> Personally, I would not be thinking about DDS described logical files.
> Just my humble opinion.
>
> Greg
>
> -----Original Message-----
> From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Thomas
> Garvey
> Sent: Friday, August 24, 2018 2:11 PM
> To: RPG programming on the IBM i (AS/400 and iSeries) <
> rpg400-l@xxxxxxxxxxxx>
> Subject: SQL Views worth it?
>
> Hi,
>
> I'm developing a new application and trying to have the DB do as much of
> the work as possible.
> So, I'm incorporating SQL Views but finding the throughput underwhelming.
> Granted that some of the views are based on other views (in keeping with
> the attempt to have the DB do some work for me) but it appears that every
> time a view is queried the views are rebuilt by the OS.
>
> I read somewhere that Views can be considered somewhat like logical files,
> but at least logicals can be set to have immediate updates as underlying
> physicals change.
> Views have no such attribute settings.
>
> So, what's considered best practices for SQL Views?
> Should I just rewrite these things as logicals?
>
> --
>
> Best Regards,
>
> Thomas Garvey
>
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD