• applying this you can reduce cluster performance.

    GO

    /****** Object: Index [IX_Stu] Script Date: 12/28/2009 11:11:43 ******/

    CREATE CLUSTERED INDEX [IX_Stu] ON [dbo].[stu]

    (

    [StuKey] ASC

    )WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]

    table (some columns omitted for brevity):

    CREATE TABLE [dbo].[stu](

    [StuCertKey] [int] IDENTITY(1,1) NOT NULL,

    [StuKey] [int] NULL

    CONSTRAINT [PK_Stu] PRIMARY KEY NONCLUSTERED

    (

    [StuCertKey] ASC

    )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 80) ON [PRIMARY]

    ) ON [PRIMARY]

    http://www.tulipvioletgurgaon.co.in/