Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tuning SQL/Response

RE: Tuning SQL/Response

From: Hamid Alavi <HamidA_at_aimdirect.co.nz>
Date: Mon, 18 Sep 2000 10:47:25 +1200
Message-Id: <10622.117211@fatcity.com>


Belinda,
What kind of sql are you using against the table, if you using any kind of function or sub etc....oracle optimiser is not going to use your index.

-----Original Message-----
From: Belinda Taylor [mailto:btaylor3_at_gmu.edu] Sent: Saturday, 16 September 2000 02:29
To: Multiple recipients of list ORACLE-L Subject: Tuning SQL/Response

We are working with Coldfusion and Oracle on a simple database which contains survey responses. I am having problems with response times from simple SQL select statements. I added indexes to fields being used for reporting purposes but nothing seems to help. Any suggestions for reducing the response time. We are trying to keep the response times down to 40 seconds; however, with no success. Most of the SQL is going against a table with approximately 70,000 records and growing.. Any suggestions would be appreciated.

-- 
Author: Belinda Taylor
  INET: btaylor3_at_gmu.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Sun Sep 17 2000 - 17:47:25 CDT

Original text of this message

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