Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Slow select count(*)

Slow select count(*)

From: <kasthuri_at_viisage.com>
Date: Tue, 02 Nov 1999 19:20:12 GMT
Message-ID: <7vndh7$cm7$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US