OraFAQ Forum: Performance Tuning » How can i tune the query...

Home » RDBMS Server » Performance Tuning » How can i tune the query...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can i tune the query... [message #292441]

Tue, 08 January 2008 23:29

ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh

Member

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

Report message to a moderator

Re: How can i tune the query... [message #292444 is a reply to message #292441]

Tue, 08 January 2008 23:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Since you found this forum, then you should have found this post
http://www.orafaq.com/forum/t/88153/0/

Let us know which suggestion from above you've completed & what were the results.

Report message to a moderator

Re: How can i tune the query... [message #292497 is a reply to message #292441]

Wed, 09 January 2008 01:22

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And also read How to Identify Performance Problem and Bottleneck .

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 05:59:24 CDT 2024