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