Subject | using select count(*) |
---|---|
Author | robertgilland |
Post date | 2006-04-17T22:50:09Z |
In our triggers and stored procedures we use
select count(*)
from table
where value = Primary Key.value
to determine whether we should run an insert or an update
query on triggered tables.
Is there a faster way?
I am half way through Helen's book "The firebird book"
She suggests never using select count(*) but I do not know a
faster way of doing this.
Regards,
Robert.
select count(*)
from table
where value = Primary Key.value
to determine whether we should run an insert or an update
query on triggered tables.
Is there a faster way?
I am half way through Helen's book "The firebird book"
She suggests never using select count(*) but I do not know a
faster way of doing this.
Regards,
Robert.