Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Tuning question: functions vs.self joins

Tuning question: functions vs.self joins

From: <sunita_at_postoffice.worldnet.att.net>
Date: 15 Aug 1998 12:12:20 GMT
Message-ID: <35D57D87.5315@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 - 07:12:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US