Subject Exists versus select first
Author Marcos Vinicius
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]