Subject | Is "EXISTS()" cheap? |
---|---|
Author | Bambang P |
Post date | 2005-09-16T12:08:56Z |
In this stored procedure statement:
if (exists(select 1 from HOLIDAYS where ADate>=DSTART and AData<=DEND))
then begin
.....
end
Question:
Does the select statement step through all records which meet the condition
or does it return immediately after the first occurance of the condition?
TIA,
--
Bambang P.
if (exists(select 1 from HOLIDAYS where ADate>=DSTART and AData<=DEND))
then begin
.....
end
Question:
Does the select statement step through all records which meet the condition
or does it return immediately after the first occurance of the condition?
TIA,
--
Bambang P.