Tag Archives: hidden column

Gather Stats on Function based filter condition in oracle

For one of performance improvement, identify root cause for bad execution plan was incorrect cardinality estimation on function based condition on a table column. As part of recommendation, we just needed to get estimated cardinality improve on table filter conditions. … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , , | Leave a comment

Histogram Statistics on Function based Index hidden column.

In one of previous post, had discussed on METHOD_OPT Params for different histogram stats setup. Current post is just an extension of previous post. If need more information on same, please check these out METHOD OPT Param for Stats in … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , | Leave a comment