| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Tuning SQL/Response
Can you give me any further informations about your environment and your =
queries ??
-----Original Message-----
From: Belinda Taylor btaylor3_at_gmu.edu
Sent: Fri, 15 Sep 2000 06:55:40 -0800
To: ORACLE-L_at_fatcity.com
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.
--=20
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).
_________________________________________________________________________=__
 |
 |