Access Path Maintenance Was RE: access path

What happens when you change access path maintenance from *DLY to *IMMED? 
Does the entire access path then get rebuilt?

Thanks,
Mark

 


Good point - for me this is primarily a possible performance improver and, 

as you say, is not always applicable.

At 09:10 AM 4/24/2003 -0500, you wrote:
> > From: Vern Hamberg
> >
> > Rebuilding? Depends on what you mean. An index is maintained every 
time a
> > record is added/removed from the physical file. The tree may need
> > balancing
> > from time to time. A complete rebuild is probably rare on the 400.
>
>I'm tired from chasing COBOL issues all night, so I'm picking nits here, 
but
>with MAINT(*DLY/*REBLD), the access paths are not automatically 
maintained,
>and there is a rebuild process.  Then again, neither of these options can 
be
>used for unique key access paths.
>
>Joe