Re: Tuning question: functions vs.self joins

From: David Sisk <davesisk_at_ipass.net>
Date: Sat, 15 Aug 1998 18:30:50 GMT
Message-ID: <utkB1.900$yo1.26605226@news.ipass.net>

Do explain plan's on a sampling of the hierarchical joins, and see if there are indexes that can be added to improve the peformance. Whether you're doing connect by SELECTs or using functions, the indexes should help.

Good luck,
Dave

sunita_at_postoffice.worldnet.att.net wrote in message <35D57D87.5315_at_postoffice.worldnet.att.net>...
>The application I am working on has many big queries
>with self joins to a table with 9000 rows.
>
>ARe the queries supposed to work faster if the self joins
>are replaced with functions?
>
>I wrote teh functions and changed teh queries and found that
>performanc eimprovement was NIL.
>
>What is your opinion? IS there a better way to
>improve the performance of queies with self joins.
>
>--
>SUnita
Received on Sat Aug 15 1998 - 13:30:50 CDT