The engineering group would like to be able to look up ECOs by ECO number or
drawing number. Currently, these are just ten-character fields but they are
not indexed.
What warnings would one heed to one going into OpenEdge and adding an index to
each of these fields in the PartRev table? The goal would be to design a
dashboard to be able to search on these items. (We would do the same for
ECORev but the table would be small enough that the search time would be
mimimal.)
Thanks,
Mark W.
drawing number. Currently, these are just ten-character fields but they are
not indexed.
What warnings would one heed to one going into OpenEdge and adding an index to
each of these fields in the PartRev table? The goal would be to design a
dashboard to be able to search on these items. (We would do the same for
ECORev but the table would be small enough that the search time would be
mimimal.)
Thanks,
Mark W.