Home » RDBMS Server » Performance Tuning » How can i tune the query...
How can i tune the query... [message #292441] Tue, 08 January 2008 23:29 Go to next message
Messages: 55
Registered: January 2007
Location: Bangladesh

Dear Friends..
How i can tune this query...it takes 10 sec for execute....
select distinct(a.employee_id), a.attendance_date,a.status,a.status_z
from HM_DAILY_ATTENDANCE_DTL a, hm_atnd_raw
b,hm_emp_proximate_mst c
where a.employee_id=c.employee_id
and b.atnd_date=a.ATTENDANCE_DATE
and a.status in 'A'

Ziaul HAque
Re: How can i tune the query... [message #292444 is a reply to message #292441] Tue, 08 January 2008 23:36 Go to previous messageGo to next message
Messages: 25531
Registered: January 2009
Location: SoCal
Senior Member
Since you found this forum, then you should have found this post

Let us know which suggestion from above you've completed & what were the results.
Re: How can i tune the query... [message #292497 is a reply to message #292441] Wed, 09 January 2008 01:22 Go to previous message
Michel Cadot
Messages: 65085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And also read How to Identify Performance Problem and Bottleneck .

Previous Topic: Bock Inefficiency 100%
Next Topic: Comparing collection against cursor
Goto Forum:

Current Time: Mon Jul 24 05:48:07 CDT 2017

Total time taken to generate the page: 0.43014 seconds