Re: joining streamed pipelined function results with "real" tables

From: dombrooks <dombrooks_at_hotmail.com>
Date: Fri, 3 Sep 2010 03:31:16 -0700 (PDT)
Message-ID: <0f43e42c-1a11-453d-ae32-fa06103d9b67_at_m15g2000yqm.googlegroups.com>

Adrian Billington has written some great stuff wrt pipelined table functions and performance.

A couple of things that you essentially touch on:
- accurate estimates to the optimizer for the pipelined function.
There are a number of different options, depending on version.
- parallelising the pipelined function

See here:
http://www.oracle-developer.net/display.php?id=427 http://www.oracle-developer.net/display.php?id=429 Received on Fri Sep 03 2010 - 05:31:16 CDT