-
Index Sizing
Anyone have a formula for calculating the size of clustered and nonclustered indexes in SQL Server 7?
I am building a sizing document and I need to know that if I insert 1 row into the following table with associated indexes, how many bytes will this take?
The row is 97 bytes + 2 bytes of overhead + 3 bytes for variable length and NULL columns for a grand total of 102.
CREATE TABLE [dbo].[ABAT] (
[FLX_PRS_OWNER] [char] (8) NOT NULL ,
[FLX_PRS_CREATOR] [char] (8) NOT NULL ,
[FLX_UPDATE_STAMP] [timestamp] NOT NULL ,
[FLX_UPDATE_DATE] [datetime] NOT NULL ,
[FLX_UPDATE_USER] [char] (20) NOT NULL ,
[ABA_INT_CODE] [int] NOT NULL ,
[ABA_NUMBER] [char] (9) NULL ,
[ABA_BANK_NAME] [char] (30) NULL ,
[TB_STATUS] [smallint] NULL
)
GO
CREATE UNIQUE CLUSTERED INDEX [ABATI1] ON [dbo].[ABAT]([ABA_INT_CODE], [FLX_PRS_OWNER]) ON [PRIMARY]
GO
CREATE INDEX [ABATI2] ON [dbo].[ABAT]([ABA_NUMBER], [FLX_PRS_OWNER]) ON [PRIMARY]
GO
Thanks.
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
|
|