Re: Tuning question: functions vs.self joins

From: jhy <jhy_at_earthling.net>
Date: 19 Aug 1998 21:10:00 GMT
Message-ID: <35DB3F2A.F4EC7D5A@earthling.net>

My experience has been that when a small number of rows is returned then functions work better than joins when large tables are involved. When a large number of rows is returned then joins are better.

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 - 16:10:00 CDT