<div>
thenelson, this is in SQL Server. you're thinking of access?
</div>


thenelson, this is in SQL Server. you're thinking of access?

<div>
Didn't notice the Zone. Just skip the Compact and repair.
</div>


Didn't notice the Zone. Just skip the Compact and repair.

<div>
well, every index will of different size, because each table will have different number of rows..
</div>


well, every index will of different size, because each table will have different number of rows..

<div>
Thanks. this works if only one index was created.
</div>


Thanks. this works if only one index was created.

<div>
<div class="content wysiwyg-content">
I have 39 tables in one schema, and they all share 2 common columns, one is a char(5) and another Date. I am planning to implement an index on each of the pair of columns in all these tables. How can I estimate how much space it will requires for the 39 new indexes, based on the datatype and number of rows in each table from sysindexes.<br />
<br />
thanks
</div>
</div>


I have 39 tables in one schema, and they all share 2 common columns, one is a char(5) and another Date. I am planning to implement an index on each of the pair of columns in all these tables. How can I estimate how much space it will requires for the 39 new indexes, based on the datatype and number of rows in each table from sysindexes.

thanks

Estimating Future Index Space

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.