More index options

By Justin James on 18 Aug 2014
We need fine-grained control over indexes. There are things like "fill factor" which we can set through SQL Management Studio, but we cannot set through Service Studio. This is a problem for 3 reasons:

1. Who knows when a deploy will wipe it out?
2. Customers on the OutSystems cloud do not have access to the DB to add it.
3. We love to manage everything through proper OutSystems tools!

J.Ja
Hans Dollen29 Sep 2015
here is the first comment.

options:
- function based indexes

and advanced options
- setting the order of columns, but now including the Tenant Identifier.
Bill Brady29 Mar 2016

How about a free-text area within the index management pop-up in Service Studio, that would simply allow you to enter the SQL required to create the desired index?

Justin James29 Mar 2016
Bill - Mainly? I'm not sure how well that would work out in terms of writing it out. It's a good idea.

J.Ja?
Bill Brady30 Mar 2016
Yeah, it pretty much relies on the person creating the index to get their syntax right, if thats what you mean.

I can't take credit for the idea, though, it was a suggestion from one of the project leads at Intel. Just helping me bang the drum ;)

Bill

Justin James30 Mar 2016
Intel is using OutSystems now? No one tells me anything anymore!?!? :) J.Ja
Bill Brady30 Mar 2016
Sometimes I feel the same way (until I make a bit of noise ;)
Happy to catch you up J.Ja! Ping me at bill.brady@outsystems.com