How to create index with Included columns

StrataFrame Forum

Back

How to create index with Included columns

Author	Message
Jiri Brazda	Jiri Brazda posted 13 Years Ago Topic Details Share Topic
Group: StrataFrame Users Posts: 78, Visits: 356	Hi, is it possible to create an index with included columns using DDT? I can create such index using management studio but I cannot see any possibility to create it with DDT. In case it is not possible - is there any workaround? Thanks George
	Reply Like 1
Edhy Rijo	E Edhy Rijo posted 13 Years Ago Post Details Share Post
E Group: StrataFrame Users Posts: 2.4K, Visits: 23K	Hi Jiri, That functionality is not included in the DDT. What I am doing is creating a Post-Deploy Script with the TSQL code to add the indexes. To get the code right, I create the index in Management Studio, then generate a script and copy the data to the DDT script, here is a sample of my script: /**** Object: Index [DuplicateImportCheck_idx] Script Date: 04/07/2010 09:50:41 ***/ IF EXISTS (SELECT FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[TransactionItemsImport]') AND name = N'DuplicateImportCheck_idx') DROP INDEX [DuplicateImportCheck_idx] ON [dbo].[TransactionItemsImport] WITH ( ONLINE = OFF ) CREATE NONCLUSTERED INDEX [DuplicateImportCheck_idx] ON [dbo].[TransactionItemsImport] ( [FK_Vendor_Carrier] ASC, [FK_Transaction] ASC, [ImportStatus] ASC ) INCLUDE ( [FK_TransactionItems], [FK_Items], [CardLotNo], [CardSerialNumber]) 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 [PRIMARY] If I remember correctly there is an enhancement request for this feature, but don't know if the SF team will add it. Edhy Rijo
	Reply Like 1
Jiri Brazda	Jiri Brazda posted 13 Years Ago Post Details Share Post
Group: StrataFrame Users Posts: 78, Visits: 356	Hi Edhy, thank You for the tip. It is working for me. However - it would be really useful to include this functionality directly to DDT. Thank You Best regards Jiri Brazda
	Reply Like 1
Edhy Rijo	E Edhy Rijo posted 12 Years Ago Post Details Share Post
E Group: StrataFrame Users Posts: 2.4K, Visits: 23K	Hi Trent, Will SF Team consider to add the feature of create index with INCLUDE columns to the DDT? I have been using the Post-Deploy script for this, but I have customers with 37GB database size and re-creating the indexes all the time in the post-script cause a long delay over 2 hours for some customers and I am under the impression that there is a logic in DDT that will only re-create an index, if it is needed to do so, is this assumption right? Edhy Rijo
	Reply Like 1