|
-
Apr 21st, 2009, 04:41 AM
#1
Thread Starter
Frenzied Member
[SQL Server] Determine or Predict the size of the Index for a table?
Hi,
Is there a way to determine the possible size the Indices of the table would take based on the table definition as well as the number of rows? The indexes are non-clustered, non-unique
If so, What about an index whose column will have null values?
-
Apr 21st, 2009, 05:52 AM
#2
Re: [SQL Server] Determine or Predict the size of the Index for a table?
Indices are basically tables that contain the actual column value and a pointer to that row.
So if it is a number field(bigint), the size should be roughly twice the number of rows * 8 bytes. etc.
Though I'm not sure about this.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
icon on the left of the post. 
