Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: statistics dbms_stats and analyze

    I am confused when I run dbms_stats on my database schema it does not refresh the last_analyzed column of the table. However, when I run the analyze command it does. How can I run dbms_stats on the entire database schema to refresh and collect accurate and up date statistics for my database? Thanks.

    Scott

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •