How to create index with Included columns


Author
Message
Jiri Brazda
Jiri Brazda
StrataFrame User (224 reputation)StrataFrame User (224 reputation)StrataFrame User (224 reputation)StrataFrame User (224 reputation)StrataFrame User (224 reputation)StrataFrame User (224 reputation)StrataFrame User (224 reputation)StrataFrame User (224 reputation)StrataFrame User (224 reputation)
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
Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)
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

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search