Subject | Exists versus select first |
---|---|
Author | Marcos Vinicius |
Post date | 2002-03-20T18:38:38Z |
Hi. What is more eficient (I mean less time to execute) to verify if exists at least one row of some table inside an trigger or procedure: if (exists(select * from t where f1 = v1...) or select first 1 * from t1 where f1 = v1... into :var1?
TIA,
Dufloth.
[Non-text portions of this message have been removed]
TIA,
Dufloth.
[Non-text portions of this message have been removed]