Re: Performance

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Fri, 15 Sep 2006 13:20:22 -0400
Message-ID: <t2olg2lbkncr9ricf03r4e8qbfal0eo5i9@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 Received on Fri Sep 15 2006 - 12:20:22 CDT