- Article Type: General
- Product: Aleph
- Product Version: 16.02
Is it necessary to run p_manage_08 for the z01 as part of the p_manage_02/Build Headings sequence of jobs?
The p_manage_08 for z01 reorganizes the table into a form which would supposedly speed up its processing by p_manage_17 and by the online system in building the Browse list display. But tests comparing runs of p_manage_17 with the z01 reorganized vs. unreorganized show *zero* difference. It may be that in earlier versions --before the addition of certain Oracle indexes?-- this did have an effect, but our recommendation is now that in 14.2 and 15.2 the running of p_manage_08 as part of the sequence of p_manage_02 Headings-building jobs be discontinued. The How To Run Index Jobs document has been updated accordingly.
- Article last edited: 10/8/2013