Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Slow select count(*)
Hi,
I am running Oracle 7.2.3 on Dec OSF 4.0d. There is a table t1 (pan
varchar(18), image long raw, len int)
A select count(*) on this tables takes a long time to return. This table
is being updated constantly and is a production database.
there is a primary key constraint on the PAN on a index_tablespace.
Any ways to improve, Please suggest
Thanks & Regards,
--
Kasthuri Jegatheesan
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Nov 02 1999 - 13:20:12 CST