4
 Followers
35
 Likes

More index options

Database
On our radar
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
Created on 18 Aug 2014
Comments (15)
here is the first comment.

options:
- 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.

J.Ja?
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

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 bill.brady@outsystems.com

Needed a filtered index today. Can't do it without going into the database and adding it manually. More options please!

This feels like a good addition to the platform. Our clients' DBAs occasionally suggest we create idexes with included columns for performance reasons, and we have to throw back the ball at them so they create the index directly in the database, which often means losing track of unmanaged resources.

I think included columns are one of the best options to add, it saves db space as opposed to including them in the index fields and it will speed up searches a lot as the index will be much smaller. 

It's a pity this important idea gets so few likes, not many people are using high volume or high speeds databases maybe? With all the emphasis from OutSystems on getting the big customers in maybe this should get more attention

Merged this idea with 'Filtered index and unique filtered index functionality' (created on 08 Jan 2020 10:41:32 by Matthew Stokes)

Hi,  would it be possible to add "filtered" index functionality to the platform?

A few benefits off the top of my head would be that this will allow us to easily create unique indexes on only active records (for example). This will also help in keeping indexes smaller and therefore save on the cost of maintenance, insert, update and query faster.

It will allow you to keep certain records unique - but exclude nulls i.e.  You want to ensure all your customer email addresses are unique - but you want to be able to have more than 1 customer without an email address.

I know MSSQL has had this functionality for some time, and after a brief search it looks like the other database platforms have similar ways of achieving the same goal.

It would be very cool to be able to implement such functionality from the entity indexes tab!



This comment was:
- originally posted on idea 'Filtered index and unique filtered index functionality' (created on 08 Jan 2020 by Matthew Stokes)
- merged to idea 'More index options' on 17 Jan 2020 03:05:55 by Justin James

Would it make sense to merge this idea with this one:

https://www.outsystems.com/ideas/1683/

?

J.Ja



This comment was:
- originally posted on idea 'Filtered index and unique filtered index functionality' (created on 08 Jan 2020 by Matthew Stokes)
- merged to idea 'More index options' on 17 Jan 2020 03:05:55 by Justin James

Hi Justin,

I have no objections to merging the ideas - my only concern is that not much has been happening on that idea for +-5 years? Perhaps too many requests on one idea?

Up to you though.

Thanks.



This comment was:
- originally posted on idea 'Filtered index and unique filtered index functionality' (created on 08 Jan 2020 by Matthew Stokes)
- merged to idea 'More index options' on 17 Jan 2020 03:05:55 by Justin James

The advantage to the merge is that it combines the votes into one bucket, to show more support for the idea. :)

J.Ja



This comment was:
- originally posted on idea 'Filtered index and unique filtered index functionality' (created on 08 Jan 2020 by Matthew Stokes)
- merged to idea 'More index options' on 17 Jan 2020 03:05:55 by Justin James
views
669
Followers
4