ANALYZE DIFFERENCES

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Mon, 05 Jun 2006 12:32 pm

I would like to know concept to apply the analyze the differences because tables are not partitioned.

a. analyze table xxxx estimate statistics sample 10 percent;

b. analyze table xxxx estimate statistics sample 10 percent for table for all indexes for all indexed columns;

c. analyze table xxxx validate structure;

d. analyze table compute statistics for table t for all indexes for all indexed columns;

e. analyze table compute statistics for xxxx table
mrj
Location: Rio de janeiro - RJ

Poston Tue, 06 Jun 2006 11:21 am

It seems that Oracle suggests that we use in place of DBMS_STATS ANALYZE.

http://asktom.oracle.com/pls/ask/f?p=49 ... 7359891525
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered


  • See also
    Replies
    Views
    Last Post


    Return to PL/SQL

    Who is online

    Users browsing this forum: No registered users and 10 guests