Re: Statistics for CBO

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Fri, 20 Oct 2006 20:26:39 GMT
Message-Id: <pan.2006.10.20.20.26.37.304762@gmail.com>

On Fri, 20 Oct 2006 21:22:55 +0200, Andrea wrote:

> but after run, where statistics are stored?? maybe in DBA_TABLES and DBA_INDEX?

Note that DBA_TABLES, DBA_INDEXES, etc. are only views. Views do not 'store' anything (unless the are materialized, but that's a vie-ble of a different colour.)

The statistics are stored in the data dictionary ... which includes the tables from which the above views are created.

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

Received on Fri Oct 20 2006 - 15:26:39 CDT