Re: Function performance question
From: Jonathan Lewis <Jonathan_at_jlcomp.demon.co.uk>
Date: 1995/11/07
Message-ID: <815780700snz_at_jlcomp.demon.co.uk>#1/1
Date: 1995/11/07
Message-ID: <815780700snz_at_jlcomp.demon.co.uk>#1/1
In article <47o26s$4ec_at_news-srv1.fmr.com> a201902 "Greg George" writes:
: Can someone explain why simple functions in Oracle (7.2.2) take such
: a long time? Is there some way for me to optimize my function compilation?
Easy,
PL/SQL is just very inefficient, and should not be used to do anything more than small, infrequent jobs. Getting it to do 42,000 of anything is guaranteed to waste a huge amount of CPU.
-- Jonathan LewisReceived on Tue Nov 07 1995 - 00:00:00 CET