Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Tuning question: functions vs.self joins
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