Why do I have such high overhead when creating tables in MSSQL7?
- by scotty2012
I have an old system running MSSQL7. It takes about 10.5 seconds to create the table below and another 30 seconds to add the index. Is there anything I can do to decrease these times?
CREATE TABLE [dbo].[MyTable] (
[queue] [int] NOT NULL ,
[seqNum] [numeric](12, 0) NOT NULL ,
[cTime] [char] (14) NOT NULL ,
[msg] [char] (255) NULL ,
[status] [int] NOT NULL ,
[socket] [int] NULL
) ON [PRIMARY]
GO
CREATE INDEX [search] ON [dbo].[MyTable]([queue], [seqNum], [status]) ON [PRIMARY]
GO
CREATE INDEX [new] ON [dbo].[MyTable]([queue], [status]) ON [PRIMARY]
