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: Fabio Nicastro <f.n_at_auselda.it>
Date: 1997/02/27
Message-ID: <33157025.5B20@auselda.it>#1/1 







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




If you are using the version 7.3 you can use the bitmap index to 
increase the performance on queries and also the hash join.



f.nicastro_at_auselda.it
Received on Thu Feb 27 1997 - 00:00:00 CST












Original text of this message













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