Re: Batch Billing Performance.

Reply to fkolmann@revlon.com.au:

Not only does the optimizer take into consideration the number of records
in your file, but it also looks at the data skew, and data key skew.  The
data is only one part of the equation.  The optimizer also looks at the
hardware configuration, specifically the memory and the number of disk arms
available.

Obviously all of these factors, and OS/400 level/PTF levels, can be very
different from implementation to implementation, and therefore an index
which may be good for one environment may have no effect or even be
detrimental to another site.

For more details on the workings of DB2/400 see the DB2 Programmers Guide,
in particular check out Appendix D for information regarding DBMON.

Regards,
Peter Greenfield


+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---