Best pratice for DoR Looping Rule to determine if DoR is new

Summary:

Customer: Deutsche Bahn AG

Use Case: 89

Content:

What is best practice when looping through a rowset of all DoR to check if a DoR of a type exists for the person:

Option 1: Combine all required criteria in one condition group in the same if statement eg

For each row

if Person ID matches AND Doc Type AND Doc ID matches

...

Option 2: Have one criteria per if clause/ add an if statement per criteria

For each row

if Person ID matches

If Doc Type matches

if Doc ID matches

...

(see also below)

Reason for asking: Ensuring best possible performance of rule