Sunday, February 19, 2012

indexes

Does anyone know how to easily calculate an index? please
dont give me that site "Estimating the size of a table
with an index" because it's complicated to read much less
understand...
PP,
if you want a non-analytical way, then empirically is the easiest, and often
the most accurate. Simply create the index and bulk load the table with 1000
rows then note the index sixe. Add another 1000 rows and note the size. Do
this several times then you can extrapolate to any number of rows to know
the index size.
HTH,
Paul Ibison

No comments:

Post a Comment