Count(*) and performance

[orajit]

Hi ,

I am using oracle 10g.
I have one table say Emp and that contains huge volume of data.
Now I wanted to select the count(*) from that data .

It takes long time to retrieve the data from that table .

Could you please suggest the alternative method for retitriving the count(*) without hampering the performance .


Thanks in advance .

[debasisdas]

use count function on the column on which there is an index.

[orajit]

Ok thanks

I will use select count(rowid) from emp;

Is it fine.

[debasisdas]

that should work for you.

[jonathan184]

try count(1)

usually this is an efficient way of using the count statement.

[debasisdas]

That won't make any difference if used on version 8i onwards.

[orajit]

thanks......... ............... .