Re: Cardinality on pipeline function

From: Dominic Brooks <>
Date: Wed, 30 Oct 2013 05:35:37 +0000
Message-ID: <DUB403-EAS140E08AE4AC12D15AD97B82A10A0_at_phx.gbl>

There are a few options.
Depending on Oracle version, you can get dynamic sampling. Also cardinality feedback can help after the initial executions. Otherwise the extensible optimizer ("associate statistics") is your best bet.

Adrian Billington has an excellent article on the various options here:

Received on Wed Oct 30 2013 - 06:35:37 CET

Original text of this message