• Subject: ECH / ECL Indexes
  • From: "Mark Curtis" <mark.curtis@xxxxxxxxxxxx>
  • Date: Tue, 20 Jul 1999 10:10:08 +0100
  • Importance: Normal

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


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].