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

I don't think it matters as much as it used to anymore with the updates to
the query engine.
It would however save some space by causing the system to reuse access
paths in the way that Mark pointed out.

Then again, is it worth the effort? Doubtful. The application performance
issues are likely due to other factors, and the only way to really ferret
those out is to use the performance tools in Navigator.

--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


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

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.

--
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.