Indexes size

[Chris]

Ho do I find or calculate the size of an index for a row in a access
database

Regards
Chris Gerhard

 

[Tim Ferguson]

Ho do I find or calculate the size of an index for a row in a access
database

1) What is "an index for a row"?

2) In general it's not possible to know the size of anything within a mdb
file, nor is it particularly helpful to know it.

3) As a practical solution, you could (a) compact the db, (b) delete the
object, and (c) recompact the db. Probably not very reproducible, though,
and there is some danger in compacting-and-repairing a non-broken database.

HTH


Tim F

 

[TC]

A >rough< calculation is to sum the actual or average lengths of the indexed
fields, then multiply by the number of records.

But as the other respondent said, this is not useful information. Why do you
want to know it?

HTH,
TC

 

[Tony]

Test
--
T

A >rough< calculation is to sum the actual or average lengths of the indexed
fields, then multiply by the number of records.

But as the other respondent said, this is not useful information. Why do you
want to know it?

HTH,
TC