Re: oracle trace file

Frank Y wrote:

> Hi All
>
> In the follow data which extracted from a trace file:
> Rows Execution Plan
> ------- ---------------------------------------------------
> 0 SELECT STATEMENT GOAL: CHOOSE
> 31 SORT (GROUP BY)
> 439211 VIEW
> 439211 SORT (GROUP BY)
> 904087 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF
> 'TTT'
> 1082389 INDEX (RANGE SCAN) OF 'IND_TTT_02' (NON-UNIQUE)
>
> ********************************************************************************
>
> There is a line: 904087 TABLE ACCESS GOAL: ANALYZED (BY INDEX
> ROWID) OF 'TTT'
>
> What does it mean?
> Can it be eleminated by manually execute "ANALYZE TABLE VEH_CROSS_ENC
> COMPUTE STATISTICS"? If yes, how often should I execute such
> analyzation?
>
> Frank.

No mention of verison so I'll assume 8.1.7 or above.

How often should you manually execute ANALYZE TABLE? Never!

You should be using DBMS_STATS for which there is copious information at http://tahiti.oracle.com.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)