Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How to forecast index sizes on new tables
0 views
Skip to first unread message
JEDBA
Mar 8, 2000, 3:00:00 AM3/8/00
to
Hi there,
Can you forecast index sizes on newly created tables, how much space
will the occupy ?
Can anyone give me the "How To' on this please.
Thans
JEDBA
* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!
Dan Guzman
Mar 8, 2000, 3:00:00 AM3/8/00
to
Check out 'Estimating the Size of a Database' in the SQL Server 7 Books
Online. This provides the calculations to estimate space requirements for a
table and associated indexes, given an estimated row count. Actual space
usage may vary due to a number for factors, such as page splits.
Online. This provides the calculations to estimate space requirements for a
table and associated indexes, given an estimated row count. Actual space
usage may vary due to a number for factors, such as page splits.
Hope this helps.
JEDBA <jerasmus...@pps.co.za.invalid> wrote in message
news:16489b6f...@usw-ex0106-048.remarq.com...
0 new messages