Also select count(1) is faster than select count(*), from my reading this is due to the fact that Oracle must identify all columns first with the select count(*) command, whereas select count(1) eliminates this step and returns the result more quickly.