8755 rows, 2 megs of data, 1 meg of index.

/****** Object: Table [dbo].[jptsys_isel] Script Date: 01/16/2013 13:35:07 ******/

CREATE TABLE [dbo].[jptsys_isel](

[jptsys_isel_id] [int] NOT NULL,

[assyst_usr_id] [int] NOT NULL,

[isel_name] [nvarchar](30) NULL,

[join_label] [nvarchar](100) NULL,

[field_name] [nvarchar](100) NOT NULL,

[col_name] [nvarchar](100) NOT NULL,

[display_value] [nvarchar](100) NOT NULL,

[display_order] [int] NULL,

[display_width] [int] NULL,

[item_order] [int] NULL,

[direction] [char](1) NULL,

[sort_alias] [nvarchar](100) NULL,

[custom_width] [int] NULL,

[hib_property] [nvarchar](254) NULL,

[is_derived] [char](1) NOT NULL,

[type] [int] NOT NULL,

CONSTRAINT [isel_pk] PRIMARY KEY NONCLUSTERED

(

[jptsys_isel_id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 30) ON [axios_seg_5]

) ON [axios_seg_4]

ALTER TABLE [dbo].[jptsys_isel] ADD CONSTRAINT [isel_pk] PRIMARY KEY NONCLUSTERED

(

[jptsys_isel_id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 30) ON [axios_seg_5]

GO

USE [AX_ASSYST]

GO

CREATE NONCLUSTERED INDEX [isel1_dx] ON [dbo].[jptsys_isel]

(

[assyst_usr_id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 30) ON [axios_seg_6]

GO

USE [AX_ASSYST]

GO

CREATE NONCLUSTERED INDEX [isel2_dx] ON [dbo].[jptsys_isel]

(

[type] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [axios_seg_4]

GO