What is the difference between using bracket on the entire index and single bracket on part of...

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...