alternative for pipelined function
Hi,
when i join pipelined function with select query it takes nearly more than 2seconds.
(pipelined function returns 31000 records)
even if i use Global temporary table to get the output of pipelined function & join tat GTT wit select query that too takes more than 5 seconds.
If i execute the pipelined fun alone it executes within fraction of second but if join wit any select query means it takes time.
please suggest any other better options for join a pipelined function.
by
Ganesh.J
Edited by: 816683 on Nov 29, 2010 9:44 PM