On 26 October 2010 12:56, AI Rumman <rumman...@gmail.com> 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
On 26 October 2010 12:56, AI Rumman <rumman...@gmail.com> 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