ECH / ECL Indexes

["Mark Curtis" <mark.curtis@xxxxxxxxxxxx>]

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
Hafele U.K. Limited
Tel : +44 (0)1788 542020
Fax : +44 (0)1788 541860
email : mailto:mark.curtis@hafele.co.uk
Web : http://www.hafele.co.uk


+---
| 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
+---