Note Submitter: El Angel [email]999@hotmail.com[/email]

----

A very more fast version of the example select would be
Select Count(*) from table

since this returns exactly the number of records of the table , but does not return any record , so its orders faster.