cdhdr too big
A program is making use of the table cdhdr
With where condition objectid AND udate. using a for all entries condition
But since this table contain 28 million data in is when a time out occur because the search is too big and also we are not making use of the primary key criteria. Please advise how this can be solve. to prevent time out
Thomas Zloch replied
Make use of the primary key criteria. No way around that.
Most of the time you are looking for change documents for a certain object (e.g. EINKBELEG = purchase orders), so always select a single value of OBJECTCLAS to even have a chance for a quick select.
Not too many values in the internal table with OBJECTIDs cannot hurt either.