Unit 2, Section 4: Routine 3: Picking List Routine

For the course labs, this video describes a routine that has a GHN that calls SEQUENTIALLY SCANs the PRODUCT database, looking for the 860 MODELSEGs that have the picking flag set and replaces them with the flag cleared. The number of I/Os cannot be estimated because the amount of I/O depends on the CISIZE and the number of database records per CI.

Tags: imsself-paced coursedatabaseperformancetuningen-usenglish (u.s.)

Appears In: IMS Educational Videos

Related Media

Unit 2, Section 4: Routine 3: Picking List Routine

Related Media