Home » RDBMS Server » Performance Tuning » Queries perform slow
Queries perform slow [message #170792] Fri, 05 May 2006 03:09 Go to next message
Messages: 70
Registered: February 2005
Location: Pune
Hi Gurus,

I have these three queries which are taking 3.5 minutes to execute on production. I came to know that in the morning these queries take few seconds to execute and as the day goes on the queries becomes slow. I dont know what may be the reason behind this. I have to suggest the way out so that this kind of behaviour can be avoided and the queries perform in the same way as they perform in the morning.

Please help me out and suggest the way out so that the queries perform better in the morning as well as late in the day.

Thanks in Advance.

  • Attachment: Queries.txt
    (Size: 14.00KB, Downloaded 1266 times)
Re: Queries perform slow [message #170793 is a reply to message #170792] Fri, 05 May 2006 03:15 Go to previous message
Messages: 7901
Registered: March 2000
Senior Member

--- Applying the filters
and W.ASSIGNED_TO = '1132' and
TRUNC(W.RECEIVED_DATE) BETWEEN '26-Apr-2005' and '26-Apr-2006' and
B.ENTITY_ID = 2142500004 and exists

Oh my god.
No binds, dates compared to strings.
Ever read/followed AskTom?
Look there for reasons behind bind-variables.
Previous Topic: Query Slow - any ideas how to speed it up??? here's what I have...
Next Topic: ip address
Goto Forum:

Current Time: Sun May 26 21:45:16 CDT 2024