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: rrbatra <rrbatra_at_feist.com>
Date: 1997/02/25
Message-ID: <3313C4A7.2F7B@feist.com>#1/1 







You may check the tablespaces. Indexes should normally be created in a
seperate tablespace for performance purposed.  Also you may look at
segment layouts and a data mapping



Good luck



Raman Batra




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 Tue Feb 25 1997 - 00:00:00 CST












Original text of this message













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