Re: [ EXTERNAL ] Re: Do any of you have a policy on rebuilding indexes?

[Ken Meade <kmeade@xxxxxxxxxxxxxxxxx>]

This raised a question for me.  How could you investigation your indices to determine last use, number of records affected, etc across all your files.
Perhaps indices are no longer required and could be deleted and would that improve performance?

Ken
----- Original Message -----
From: "Rob Berendt" <robertowenberendt@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxxxxxxxx>
Sent: Thursday, March 30, 2023 10:25:16 AM
Subject: [ EXTERNAL ] Re: Do any of you have a policy on rebuilding indexes?

Basically, if they're going to just shotgun blast an index rebuild they may
end up shooting themselves in the foot.

On Thu, Mar 30, 2023 at 10:22 AM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

> In general I do not see the benefit.  However it may make a difference in
> the order the indexes were built.  For example, which is the proper order
> to build these two indexes?
> order, line, receipts (handles partials)
> order, line
> or
> order, line
> order, line, receipts
>
>
> On Thu, Mar 30, 2023 at 8:48 AM Mark Murphy <jmarkmurphy@xxxxxxxxx> wrote:
>
> > We have a client who wants to rebuild indexes, just because they haven't
> > been built for a long time (3-4 years). They think it will improve
> > performance. I've never rebuilt indexes to improve performance. Does
> > anyone
> > have an opinion on this?
> > --
> > 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.