Home » RDBMS Server » Performance Tuning » Response time
Response time [message #65966] Tue, 08 February 2005 00:39 Go to next message
Nainar
Messages: 35
Registered: January 2005
Member
Hi,
I'm having 3 tables X,Y,Z. The data size of the tables are X - 4413314,Y - 284440,Z - 6668. I'm fetching the X tables data with various conditions of Y and Z. My query is taking around 2 min to fetch 150-200 records. I've checked the Explain Plan for the query and its using Index properly. I've used /*first_rows +100 */ HINTS also. I've to reduce the response time further. Is there any way to reduce the time?

Nainar
Re: Response time [message #65967 is a reply to message #65966] Tue, 08 February 2005 03:39 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.orafaq.com/forum/t/23605/0/

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Previous Topic: SGA Tuning
Next Topic: Writing a Performance Stress Test
Goto Forum:
  


Current Time: Fri Mar 29 08:46:11 CDT 2024