erickroco9611
New Member
Which is BEST PRACTICE...!!??
for each po
where po.whs-code = "10"
and po.cust-no >= 1000
and po.cust-no <= 9999
and po.dt-cancel = ? no-lock:
.... [PROCESS]...
end.
OR
for each po
where po.whs-code = "10"
and po.cust-no >= 1000
and po.cust-no <= 9999 no-lock:
if po.dt-cancel <> ? then next.
.... [PROCESS]...
end.
OR
!!! Maybe you have a better idea !!!
Considering that po.dt-cancel isn´t part of any INDEX in the table.
In the first example how can affect the performance?
Thak you very much... I really appreciate your time!!!
for each po
where po.whs-code = "10"
and po.cust-no >= 1000
and po.cust-no <= 9999
and po.dt-cancel = ? no-lock:
.... [PROCESS]...
end.
OR
for each po
where po.whs-code = "10"
and po.cust-no >= 1000
and po.cust-no <= 9999 no-lock:
if po.dt-cancel <> ? then next.
.... [PROCESS]...
end.
OR
!!! Maybe you have a better idea !!!
Considering that po.dt-cancel isn´t part of any INDEX in the table.
In the first example how can affect the performance?
Thak you very much... I really appreciate your time!!!