1
 Follower
12
 Likes

re-order indexes attributes

Database
New

I think it could be useful to re-order in some way the attributes in a created index.

For Example a Index, where we have attributes (Attribute1: Name, Attribute2: Code) and I wanted to place Code in 1st place. From what we have now, I need to change each attribute, when we could just "move" one to the top and the other to the bottom.

I think this could be useful, because from what I understood from performance perspective, It matters which attribute comes first in the index. 

Created on 8 Dec 2018
Comments (2)

Changed the category to Database


Indeed the order of the columns influences the index and changing the order of multi column indexes on Outsystems is painful. 


A good way to change the order of the index columns would be some shortcut like on the assigns: 

Ctrl + Up arrow or Ctrl + Down arrow

views
455
Followers
1