How does oracle evaluate where clauses?

[Quoted] [Quoted] Can anybody tell me how oracle would evaluate the following simple where clause in this select statement:

select fielda
from tablea
where fielda = sysdate;

Does oracle evaluate sysdate once for the where clause and then use that value to compare with each row or does it evaluate the value of sysdate for every row returned by the select?

Cheers,

Jon. Received on Fri Jun 04 1999 - 11:07:49 CEST