| Queries perform slow [message #170792] |
Fri, 05 May 2006 03:09  |
milind_sri
Messages: 70
Registered: February 2005
Location: Pune
|
Member |
|
|
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.
Milind.
-
Attachment: Queries.txt
(Size: 14.00KB, Downloaded 1391 times)
|
|
|
|
| Re: Queries perform slow [message #170793 is a reply to message #170792] |
Fri, 05 May 2006 03:15  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
| Quote: |
--- 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
