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 -> Re: index fast full scan - why so slow and expensive

Re: index fast full scan - why so slow and expensive

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 02 Feb 2005 11:41:52 +0100
Message-ID: <bjb101t1pq11un91qrtmm4ocvk08ov8ekq@4ax.com> 





On 1 Feb 2005 13:50:24 -0800, iamoracledba_at_gmail.com wrote:



...


>I have a table with about 16m rows. When end users try to pull up

>reports using the table, response is very slow, if they try to pull up

>more, cpu will spike up to 100%



...



Where do you see that 100% CPU? On the database server or the end user
desktop?



Jaap.
Received on Wed Feb 02 2005 - 04:41:52 CST












Original text of this message













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