Re: Tunning Indexes

From: Tanel Poder <tanel_at_@peldik.com>
Date: Sun, 20 Jul 2003 20:07:47 +0300
Message-ID: <3f1acc64$1_1@news.estpak.ee>

A small "typo".
In my previous post I highlighted wrong fields in second statistics list, the correct would be:

SQL> select index_name, leaf_blocks, num_rows, clustering_factor from user_indexes;

INDEX_NAME                     LEAF_BLOCKS   NUM_ROWS CLUSTERING_FACTOR
------------------------------ ----------- ---------- -----------------
I                                       65      29764               398
I2                                      65      29764             14810
J                                      145      29764             13749
J2                                     145      29764               710

4 rows selected.

Tanel. Received on Sun Jul 20 2003 - 12:07:47 CDT