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

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.