>Hi All,
>i've a query for stock analysis ( about buying selling quantities and avg prices for its )
>i think it takes alot of time and some fields comings null
>here is my code, where is the wrong or what should i do for optimization for this queries ?
>is there any wrong join ?

Have you used SYS(3054) to see where it's slow?

Tamar