Index length 
Author Message
 Index length

Anyone could explain me how colculate the record length of an index ?

thanks




Tue, 05 Sep 2000 03:00:00 GMT
 Index length

Quote:

> Anyone could explain me how colculate the record length of an index ?

You can calculate the *average* length of an index key ... it's
pretty easy.

analyze index OWNER.INDEX_NAME validate structure;

select * from index_stats;

The index_stats view will show you some vital statistics about
the index you just validated.  Pay attention to the LF_ROWS_LEN
and the LF_ROWS.

LF_ROWS:  Number of leaf rows in the index.
LF_ROWS_LEN:  Sum of the length of all leaf rows.

The average length of an index leaf row is therefore
LF_ROWS_LEN / LF_ROWS.

You also might want to consider the index /branch/ size,
computed similarly with BR_ROWS_LEN / BR_ROWS ...

--
-brett neumeier



Sat, 09 Sep 2000 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Maximum index length????

2. Index length

3. Limited Text field index length??

4. DDF Index length

5. row length and index limitations for sql 7

6. columns names,datatypes,length and indexes !

7. index and sequence name length limit?

8. Problem: database table/index sizing for Sum Length Columns greater than Available Data Space

9. Primary Keys/Index Keys Length

10. Weblogics/DB2/length index names

11. Length of index key

12. BCP OUT Fixed-Length Record: Truncated Length


 
Powered by phpBB® Forum Software