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: To Mr oracle .My datbase query is using indexes but is still very very slow 1 min. How can this be .

Re: To Mr oracle .My datbase query is using indexes but is still very very slow 1 min. How can this be .

From: Russ Eberle <russ.eberle_at_born.com>
Date: 1997/02/28
Message-ID: <5f5e7e$9bc@news.mr.net>#1/1 







Also, compute or estimate statistics on the table and take a look at
the chain_cnt.  Severe (even not-so-severe) chaining can also degrade
the query performance.



"CHEELYM9_at_spanky.badm.sc.edu" <CHEELYM9_at_spanky.badm.sc.edu> wrote:



>3 weeks ago I was tunning a query that select from 3 large table

>400K rows each. My query is using indexes. It is taking 1.20 min to 

>come back.

 


>Can anybody tell How fast Oracle can query database, and how fast oracle

>Corporation said about the speed of a query.

 


>KHALID BOUSSIF


>kboussif_at_sctcorp.com

Received on Fri Feb 28 1997 - 00:00:00 CST












Original text of this message













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