Tag Archives: histogram

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

Understand METHOD OPT Param for Stats in Oracle

In Oracle Statistics about database objects like Table, Index etc. is Core component for Cost based Optimizer for better Plan Estimation. It is the basic ingredient that decides different SQL Plan component (Access path / Join Order / Cardinality / … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , , | 4 Comments

Explain plan Command : Why we should not rely for exact runtime plan.

For getting SQL plan we have lot of method in oracle, one of them being EXPLAIN PLAN FOR Command.We use EXPLAIN PLAN Command to get estimated Plan without running the SQL. Oracle perform parsing on SQL and store estimated plan … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , , | 5 Comments