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

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

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.