There has been a long-standing doubt about the performance of the count statement. I was told by experienced developers in PL/SQL that using count(1) to find the rowcount was much more high-performing than using count(*), as count(*) fetches all the rows
Read More...
