• Post Reply Bookmark Topic Watch Topic
  • New Topic

Calculate Working hours

 
Baktha Elumalai
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I am using the below sql query to calculate working hours. The problem which i am facing is that query is taking lot of time to calculate the working hours. Please help to reduce the execution time of this query or if there is any other way to calculate working hours

The following query take 63.499 sec


please help me how do i change the query to reduce the sec.

Bakthavachalam E
 
Ireneusz Kordal
Ranch Hand
Posts: 423
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ask this question on this forum:
http://forums.oracle.com/forums/forum.jspa?forumID=75

But first read this topic:
http://forums.oracle.com/forums/thread.jspa?threadID=863295
 
Baktha Elumalai
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ok
thanks for your reply
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!