re: Count(*) takes forever

Hi,

1. Put the table into cache. alter table tablename cache;
2. if you have a single column on the table as the primary key, of type number(x,0), then:

select count(primary_key) from table where primary_key > 0;

Works for me :-)

...later Received on Fri Feb 05 1999 - 10:02:49 CST