[Stackoverflow] [Progress OpenEdge ABL] What is the difference between using bracket on the entire index and single bracket on part of one index?

Status
Not open for further replies.
T

Thiru Malai

Guest
somebody says using single bracket on part of one index is more faster than normal query. Like below examples.

Raising question on stack overflow then i can get exact answer from professionals

/* Normal Way */
FOR EACH customer NO-LOCK WHERE customer.name EQ 'John':
DISPLAY customer.name.
END.

/* Fastest Way to retrieve data from table*/
for each customer where (customer.name EQ 'John'):
DISPLAY customer.name.
end.



Could you please explain which way is more flexible and fastest way to retrieve data from table?

Continue reading...
 
Status
Not open for further replies.
Top