Re: Explain Plan.....plan_table.cost and plan_table.cardinality

Zoom Zoom Zoom <satnic_at_home.com> wrote:
>I am just ran the explain plan for one of the sql statement in Oracle 8.1.7
>and did select from plan_table. Although I could see the :
>operation, options and object_name columns, the COST and CARDINALITY columns
>are null. Why are not they getting populated?

Do all the objects involved in the query have statistics (i.e. are they analyzed)?

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/