In reply to Chris Hemedinger.

not sure create table _null_ as select * from ... would be faster than

select count(*) into :resultcount from ...

I would suggest people try this both ways on some of their bigger tables.