Home » RDBMS Server » Enterprise Manager » counting records
counting records [message #67987] Mon, 26 August 2002 06:12 Go to next message
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
Re: counting records [message #67988 is a reply to message #67987] Mon, 26 August 2002 22:29 Go to previous message
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: Wed May 18 01:10:54 CDT 2022