Ken,

	IIRC, since your sort key is at the end of the data set, then
you need only sort by the sort key value.



-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Kent Wallace
Sent: Wednesday, February 01, 2006 9:40 AM
To: [log in to unmask]
Subject: [HP3000-L] IMAGE sort key

I (we) am loading a lot of data into a detail data set in IMAGE with a
sort key.  Do I presort the data by the sort key only?  Or do I presort
by the Automatic key then the sort key?

 

 

As in:

 

   Entry:                     Offset

      BP-EXPLODE#          X10     1  (!BP-EXPLODE-A(PRIORITY))

      BP-BENEFIT           X10    11  (BP-BENEFIT-A)

      COMPONENT            X4     21

      RIDER-TITLE          X8     25

      YMDEFF               X8     33

      YMDEND               X8     41

      PRIORITY             X2     49

 

I know this really improve performance.

 

Thanks

Kent Wallace

 

 

 

 


* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *