Re: can't get the Query Cost!

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: Thu, 23 Dec 1999 18:19:07 +0100
Message-ID: <83tliu$8muh$1@fu-berlin.de>

Hi,

Use the command

analyze table <TABLENAME> compute statistics

or for the full schema:

EXEC dbms_utility.analyze_schema('PMIS','COMPUTE');

Bye
Uli
> I use 'Explain plan set statement_id ='aa' for &sql'
> to get the query execute path!
> but the results in different user are different!
> in user 'pmis'
> I can get the cost values in plan_table
> but in user 'pmis1'
> I can not get the cost values in plan_table,
> they are all null!
> why?
Received on Thu Dec 23 1999 - 11:19:07 CST