OraFAQ Forum: Performance Tuning » Function taking very long to execute

Home » RDBMS Server » Performance Tuning » Function taking very long to execute

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

Function taking very long to execute [message #164741]

Sat, 25 March 2006 05:29

alfatat
Messages: 2
Registered: March 2006

Junior Member

Hi!
I am pasting the main query of my function which is taking too long to get executed.

select @qtyo = sum(cod.quantityOrdered)
from codetails cod
inner join coheader ch on ch.coid = cod.coid
Inner join ooheader oh on ch.coid = oh.coid
Where ooid = @ooid

Each of the table exploited has around 5000 rows.

Reply ASAP

Junaid

Report message to a moderator

Re: Function taking very long to execute [message #164747 is a reply to message #164741]

Sat, 25 March 2006 05:37

Frank
Messages: 7901
Registered: March 2000

Senior Member

This is an Oracle forum; your query looks like Sybase/SQLServer.

Report message to a moderator

Previous Topic:	help!!->resolving "cpu time" problem
Next Topic:	SQLTRACE AND DB_FILE_SEQUENTIAL_READ

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 05:24:51 CDT 2025