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

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

From: <CHEELYM9_at_spanky.badm.sc.edu>
Date: 1997/02/23
Message-ID: <33106E51.7CCA@spanky.badm.sc.edu>#1/1

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 Sun Feb 23 1997 - 00:00:00 CST

Original text of this message

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