Home » RDBMS Server » Performance Tuning » Function taking very long to execute
Function taking very long to execute [message #164741] Sat, 25 March 2006 05:29 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 08:35:09 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.