count(*)

[orajit]

I am using Oracle 10g

I am executing select count(*) from emp ;

Emp table has millions of rows .

Could you please tell me which option is better.

Select count(1) from emp;
or
Select count(*) from emp;

And Why ...

[amitpatel66]

Did you test and checked the outcome?

[orajit]

ya ..it gives me same result ..but i am asking about performance ..which one is better count(*) or count(1)..

Please advice...

[debasisdas]

There is no difference in the performance if you are using version 8 onwards.