Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
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 .
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
Just because a query uses an index does not mean it is going to be fast. The statement may need tuned, the index may be a bad index to use, or depending on the amount of data you will be retrieving indexes may not be the way to go. The power of the machine will also have an impact.
There are a lot of things that you will need to look at. If you get a little more specific it would be easier to help
-- ---------- Greg Pucka Management Consultant, TUSC puckag@tusc.com --- http://www.tusc.comReceived on Sun Feb 23 1997 - 00:00:00 CST