Re: Cardinality on pipeline function
From: Dominic Brooks <dombrooks_at_hotmail.com>
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.
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: http://www.oracle-developer.net/display.php?id=427
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 30 2013 - 06:35:37 CET