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

[Mark Murphy <jmarkmurphy@xxxxxxxxx>]

Lots of good info here confirming my suspicions (that there won't be much
use in rebuilding indexes). Even the fragmentation issues probably aren't
what they used to be with SSD's in place now. No hardware to move to get to
a different place on the platter.

On Thu, Mar 30, 2023 at 1:17 PM Gavin Inman <midrangelist@xxxxxxxxxxxxxx>
wrote:

> If they want to improve performance, look at the index advisor and
> create real index's for the temporary ones that are show at the top of
> the list.
>
> On 3/30/2023 8:48 AM, Mark Murphy 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.