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

From: Strategic Data Systems <sds_at_dataplusnet.com>
Date: 1997/02/27
Message-ID: <5f50vs$pc6$1@news.inc.net>#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

I would either run a 'tkprof' on a trace of the query or 'explain plan' to determine if Oracle IS using the indices. Received on Thu Feb 27 1997 - 00:00:00 CST