OraFAQ Forum: Enterprise Manager

Home » RDBMS Server » Enterprise Manager » counting records

Mon, 26 August 2002 06:12

Daniele Rattellini
Messages: 38
Registered: August 2002

Member

Hi,
why this statement is so slow?

select count(*) from big_table

is there a faster way to do this?

regards

daniele

Mon, 26 August 2002 22:29

Basarab A
Messages: 1
Registered: August 2002

Junior Member

Hi!

Try

select count(rowid) from big_table;

Previous Topic:	Oracle management server.
Next Topic:	Intallation Of Enterprise Manager

Goto Forum:

]

Current Time: Fri Nov 22 20:31:48 CST 2024