Skip to Content
author's profile photo
Former Member

Update Stats with Force Option - DB13

Basis Gurus,

How to run UPDATE STATS (Using DB13) with FORCE option and the same command should not run for POOL & CLUSTER tables?

Is this command ( Brconnect –u / -c –f stats –t all –f collect ) will resolve the above issue?

Paramter (stats_dbms_stats) is set in init<sid>.sap file.

Quick Feedback will be appriciated.

Thanks,

Ramesh

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Posted on Sep 28, 2007 at 06:42 AM

    Hi,

    Would you mind to indicate your database and BRconnect version?

    Would you mind to indicate <b>why</b> do you eant to calculate statistics on those tables?

    If you are in 9i it is normal that pool and cluster tables do not have statistics, they are suposed not ot have them.

    The mentioned command will NOT collect statistics on pool and cluster tables but it will do it on ALL +25000 SAP tables. I'm not sure that you want to do so.

    Add comment
    10|10000 characters needed characters exceeded