function call from a view slows things down ?

From: <jeanch_at_my-deja.com>
Date: 2000/06/09
Message-ID: <8hqomk$qcm$1@nnrp1.deja.com>#1/1

Folks,

I was wondering if any of you had an idea why this view will run slower than normal view.
o As you've noticed, a function call from the view is operated and the the data type passed to getData function is VARCHAR2 and the col1 datatype on the table is a number; basically I do some data conversion from number to formatted string process before printing data.

o likewise I use a trigger on the view to allow ne the conversion back from varchar2 to number before inserting into the table; that as well is a slow process.

CREATE OR REPLACE VIEW myview ( col1, col2) AS SELECT scott.mypkg.getData(tab.col1, tab.col2) col1,

     tab.col2 SIGNALING_POINT_NAME
          FROM mytab tab

Cheers
JC

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 09 2000 - 00:00:00 CDT