ANALYZE INDEX <index-name> VALIDATE STRUCTURE; SELECT LF_BLKS, LF_ROWS FROM INDEX_STATS; on 4/3/04 9:45 PM, Helen J Mitchell at helenjmitchell@xxxxxxxxxxx wrote: > Do you have a script that counts the number of leafs for an index? ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------