On Sat, Jan 6, 2018 at 11:32 AM, Arun Venkatratnam <[email protected]> wrote: <deleted> > Resp: Reading through the entire file by sequential access took 90 CPU > seconds while skip-sequential took nearly 230 CPU seconds. > Doing the skip sequential (read by key) requires accessing the index to find the next record. Just skipping through non-matching records is faster when you are reading a large subset of the records. A sort to match up the records to create an extract for further processing could be even faster.
-- Mike A Schwab, Springfield IL USA Where do Forest Rangers go to get away from it all? ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
