Tips: Add to Google | Oracle DUL? | AUL License | AnySQL.net | asyncdata | ociuldr

Contact: anysql©yahoo.com/anysql©126.com, MSN: loufangxin©msn.com, AIM: loufangxin

Compute statistics when creating index will analyze table in Oracle 9i

    I have a table named "T_OBJECTS" and one index on it named "T_OBJECTS_IX1". They are not analyzed now: TABLE_NAME       NUM_ROWS LAST_ANALYZED -------------- ---------- --------------- T_OBJECTS T_OBJECTS_IX1     Now I receive a task to create a second index...

Tags:

Posted on October 10, 2007 5:15 PM

Analyze or DBMS_STATS, choose one but don't mix them

    I am not so familiar with the DBMS_STATS procedure, so I always use the "ANALYZE" command. One day I got the following problem. Let's start a demo, first step is creating demo partitioned table. SQL> CREATE TABLE T_PARTDEMO(...

Tags:

Posted on September 29, 2007 12:37 PM