|Subject||Re: [firebird-support] Is "EXISTS()" cheap?|
On Friday, September 16, 2005, 9:08:56 AM, you wrote:
> In this stored procedure statement:
> if (exists(select 1 from HOLIDAYS where ADate>=DSTART and AData<=DEND))
> then begin
> Does the select statement step through all records which meet the condition
> or does it return immediately after the first occurance of the condition?
Yes, it returns immediately after having found the first ocurrence
meeting your condition.