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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Pipelined function consumes memory

Re: Pipelined function consumes memory

From: AK <ak_tiredofspam_at_yahoo.com>
Date: 28 Nov 2004 17:44:17 -0800
Message-ID: <46e627da.0411281744.48a6ca47@posting.google.com>


when I was doing my own benchmarking in my environment, a materialized calendar table performed the best. Actually the best performer was an index organized calendar table.

Have you compared your pipelined function's perfomance vs. the performance of a simple select from a calendar table? Received on Sun Nov 28 2004 - 19:44:17 CST

Original text of this message

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