Re: Tuning question: functions vs.self joins

From: Rajneesh Kwatra <rk88_at_pantheon.yale.edu>
Date: Wed, 19 Aug 1998 14:27:11 -0400
Message-ID: <35DB18FF.E39439DA@pantheon.yale.edu>

You can get improved performance by using functions, provided all the sql used is properly tuned especially taking care of the queries in the functions. An inefficient SQL in a function would actually degrade performance.

sunita_at_postoffice.worldnet.att.net wrote:

> 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 Wed Aug 19 1998 - 13:27:11 CDT