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!

Hans Dollen29 Sep 2015
here is the first comment.

- function based indexes

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

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?

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

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 ;)


Intel is using OutSystems now? No one tells me anything anymore!?!? :) J.Ja
Sometimes I feel the same way (until I make a bit of noise ;)
Happy to catch you up J.Ja! Ping me at