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

Home -> Community -> Usenet -> c.d.o.server -> how to speed up a "select count(*) from ..."

how to speed up a "select count(*) from ..."

From: Paolo Polce <java.group_at_bricabrac.it>
Date: 2000/05/05
Message-ID: <8eu49s$4676$1@stargate1.inet.it>#1/1 






Hello,



  I have a table with 40.000 records. There was no primary key on the table
(!) and a "select count(*) from mytable" took about 15 sec.
So, now, I've created a primary index on mytable.id field...



Well... it still takes 15 sec to count the records... :-(
May someone help me?



Thank you.


Paolo.
Received on Fri May 05 2000 - 00:00:00 CDT












Original text of this message













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