Re: ECH / ECL Indexes

In a message dated 7/20/99 6:00:51 AM Central Daylight Time, 
mark.curtis@hafele.co.uk writes:

> 6.0.04 Sept 98, HP-UX / Informix
>  
>  I would like to add an index to ECH and ECL on hid and lid followed by
>  various other fields.
>  
>  I have added a number of indexes to BPCS tables before and achieved in some
>  areas significant performance improvements.
>  
>  I am however nervous about adding these as they seem obvious ones to exist
>  as standard (to aid views ecll01 & echl01) but are not there (when you use
>  ecll01 or echl01 the engine performs a sequential read of the tables to
>  filter for hid and lid)
>  
>  Does anybody know why such indexes do not exist ?
>  Has anyone added these indexes (successfully or otherwise) ?
>  
>  Regards
>  Mark Curtis
>  IT Director

Add them definately. If you ECH file is large, they will help a lot.

Keys by ID and Then Order, or just order will help a lot in order entry, 
picking, and shipping if you have many records.

As to why the ECHL02 does not include all records? pure stupidity.
+---
| 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
+---