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

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

This kind of stuff was what I was stressing that the order of creating the
keys might matter.

On Thu, Mar 30, 2023 at 11:26 AM Mark Waterbury <
mark.s.waterbury@xxxxxxxxxxxxx> wrote:

> See the following articles / presentations for details about sharing
> access paths between DDS LFs and SQL INDEXes.
>
>
> https://www.ibm.com/support/pages/system/files/inline-files/Indexing%20and%20Statistics_1.pdf
>
> and
>    https://public.dhe.ibm.com/partnerworld/pub/pdf/courses/29a2.pdf
>
> If you create SQL INDEXes first, when you create LFs over the same PFs
> that have SQL INDEXes, they can "share" access paths, and you get the
> benefit of the larger page size.
>
> --
> 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.