Re: Performance

"NetComrade" <netcomradeNSPAM_at_bookexchange.net> kirjoitti viestissä:t2olg2lbkncr9ricf03r4e8qbfal0eo5i9_at_4ax.com...
> On Fri, 15 Sep 2006 10:05:37 GMT, "Jack" <none_at_INVALIDmail.com> wrote:
>
>>
>>>> Statistics
>>>> ----------------------------------------------------------
>>>> 1939 recursive calls
>
>>count
>>Table Prod Test
>>------------- ---------- --------------------
>>TILAUSRIVI 11380 7300
>>KAAPELI 8951 7424
>>TILA 8770 7885
>>kaapeliryhma 27 24
>>tyotilaus 3284 2257
>>til_kaapeli_tila 2675194 1612440
>>
>>There is selection from view til_kaapeli_tila , and that should get
>>faster.
>>That view is based on those five tables.
>>CBO in 9.0 is not usefull with complex views. so we are using RBO.
>>(even this view is not so complicated, it is quite simplex, one page long)
>
> I bet your view is using functions, and your function is what slows
> down your query. Tune the function, and learn to use CBO as Sybrand
> stated.
> .......
> We run Oracle 9iR2,10gR1/2 on RH4/RH3
> remove NSPAM to email

Surely tuning migth give 5-10% or more and maybe CBO that same, but not 500-1000%

But best and cheapest way wuold be upgrade and new hardware. Or any better ideas? Received on Fri Sep 15 2006 - 14:39:17 CDT