Estimating Future Index Space

anushahanna
anushahanna used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Compact and repair. Check the db size. Create the indexes for one table. Compact and repair. Check the db size. Subtract, multiply by 39.

Author

Commented:
thenelson, this is in SQL Server. you're thinking of access?
Didn't notice the Zone. Just skip the Compact and repair.

Author

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

Author

Commented:
Thanks. this works if only one index was created.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial