oracle trace file

From: Frank Y <dmx_frank_at_yahoo.com>
Date: 29 May 2003 00:01:06 -0700
Message-ID: <9d599275.0305282301.734e7122@posting.google.com>

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. Received on Thu May 29 2003 - 02:01:06 CDT