Sort by BP-EXPLODE# as 1st key and PRIORITY as 2nd key within BP-
EXPLODE#.

Denys

----- Original Message -----
From: Kent Wallace <[log in to unmask]>
Date: Wednesday, February 1, 2006 9:39 am
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 
> presortby 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 *