| Response time [message #65966] |
Tue, 08 February 2005 00:39  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
