Re: Cardinality on pipeline function

From: Dominic Brooks <dombrooks@xxxxxxxxxxx>
To: "huanshengchen@xxxxxxxxx" <huanshengchen@xxxxxxxxx>
Date: Wed, 30 Oct 2013 05:35:37 +0000

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

--
//www.freelists.org/webpage/oracle-l

References:
- Cardinality on pipeline function
  - From: Sidney Chen

Other related posts:

» Cardinality on pipeline function- Sidney Chen
» Re: Cardinality on pipeline function - Dominic Brooks