Re: which one is faster

[Szymon Guz <mabewlun@xxxxxxxxx>]

On 26 October 2010 12:56, AI Rumman <rummandba@xxxxxxxxx> wrote:

Which one is faster?

select count(*) from talble

or

select count(id) from table

where id is the primary key.

Check the query plan, both queries are the same.

regards

Szymon