Does source control recognize Fill Factor and index padding?
sat
Posts: 9
Redgate source control does not seem to recognize Index's "Fill Factor and index padding" changes.
Is there any option for fill factor setting?
/*** SCRIPT to create table with index fill factor andpadding ******/
-- Columns
CREATE TABLE [dbo].[test]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[column1] [int] NULL,
[column2] [int] NULL,
[column3] [int] NULL,
[column4] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
-- Constraints and Indexes
ALTER TABLE [dbo].[test] ADD CONSTRAINT [PK_test] PRIMARY KEYCLUSTERED ([id]) WITH (FILLFACTOR=90,PAD_INDEX=ON)
GO
CREATE NONCLUSTERED INDEX [IX_test] ON [dbo].[test] ([column2]) WITH(FILLFACTOR=90, PAD_INDEX=ON)
GO
CREATE NONCLUSTERED INDEX [IX_test_1] ON [dbo].[test] ([column4]) WITH(FILLFACTOR=90)
GO
/************* SOURCE CONTROL OUTPUT ************/
-- Columns
CREATE TABLE [dbo].[test]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[column1] [int] NULL,
[column2] [int] NULL,
[column3] [int] NULL,
[column4] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
-- Constraints and Indexes
ALTER TABLE [dbo].[test] ADD CONSTRAINT [PK_test] PRIMARY KEYCLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_test] ON [dbo].[test] ([column2]) ON[PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_test_1] ON [dbo].[test] ([column4]) ON[PRIMARY]
GO
Is there any option for fill factor setting?
/*** SCRIPT to create table with index fill factor andpadding ******/
-- Columns
CREATE TABLE [dbo].[test]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[column1] [int] NULL,
[column2] [int] NULL,
[column3] [int] NULL,
[column4] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
-- Constraints and Indexes
ALTER TABLE [dbo].[test] ADD CONSTRAINT [PK_test] PRIMARY KEYCLUSTERED ([id]) WITH (FILLFACTOR=90,PAD_INDEX=ON)
GO
CREATE NONCLUSTERED INDEX [IX_test] ON [dbo].[test] ([column2]) WITH(FILLFACTOR=90, PAD_INDEX=ON)
GO
CREATE NONCLUSTERED INDEX [IX_test_1] ON [dbo].[test] ([column4]) WITH(FILLFACTOR=90)
GO
/************* SOURCE CONTROL OUTPUT ************/
-- Columns
CREATE TABLE [dbo].[test]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[column1] [int] NULL,
[column2] [int] NULL,
[column3] [int] NULL,
[column4] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
-- Constraints and Indexes
ALTER TABLE [dbo].[test] ADD CONSTRAINT [PK_test] PRIMARY KEYCLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_test] ON [dbo].[test] ([column2]) ON[PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_test_1] ON [dbo].[test] ([column4]) ON[PRIMARY]
GO
Comments