[Vince]

Quote:

Originally Posted by KingHual use SELECT COUNT

This. There are usually multiple ways to get to the result, but they are not all equally efficient. Selecting a single number is obviously going to be much faster than loading an entire result into memory.