Re: Preformance in multiple join
I see the point with the group by, the posted SQL is just for test.
The Count(DISTINCT data_id) as Calls works well but I can not find a way to get the right duration out. The same happens with the duration if more prices are related to the call then it is multiplied by the amount of related prices.
Tanks
Rasmus
Subject
Written By
Posted
Re: Preformance in multiple join
January 17, 2007 07:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.