Hello folks, This is a curiousity question. When I do a JOINKEYS operation and I have a really big keyed VSAM file(Say one million records), and a relatively small (Say 100 records) non-sequenced flat file, does it make any difference to performance, which file is File1 and which file is File2?
I would think I want to grab a record from the smaller file and then do a keyed read from the very large file. JOINKEYS F1=VSAMFILE,FIELDS=(1,25,A),SORTED JOINKEYS F2=FLATFILE,FIELDS=(1,25,A) or JOINKEYS F1=FLATFILE,FIELDS=(1,25,A) JOINKEYS F2=VSAMFILE,FIELDS=(1,25,A),SORTED Maybe it makes no difference? Thanks ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
