logic of dropping (and recreating ) DB index.

Hi All :


confused about who OS handle index when deploy application .


Story:

We have a index on ID column Business entity , once the application is deployed , index OSIDX_OSUSR_PPC_BUSINESS_71993 is created on column ID  , table business . 


later on, for some reason , DBA manually created another index on same column , with name OSIDX_OSUSR_PPC_BUSINESS_02. 


Then application was updated (without touch of Business entity ) and deployed again,  however OSIDX_OSUSR_PPC_BUSINESS_71993 is dropped by OS and OSIDX_OSUSR_PPC_BUSINESS_02 os remained untouched .


we tried few other scenarios found some time OS drop a index that manually created ,some time it drop index that created by OS.


appreciate if someone has insight and can share some hint how OS manage database index.

 



dan guo wrote:

Hi All :


confused about who OS handle index when deploy application .


Story:

We have a index on ID column Business entity , once the application is deployed , index OSIDX_OSUSR_PPC_BUSINESS_71993 is created on column ID  , table business . 


later on, for some reason , DBA manually created another index on same column , with name OSIDX_OSUSR_PPC_BUSINESS_02. 


Then application was updated (without touch of Business entity ) and deployed again,  however OSIDX_OSUSR_PPC_BUSINESS_71993 is dropped by OS and OSIDX_OSUSR_PPC_BUSINESS_02 os remained untouched .


we tried few other scenarios found some time OS drop a index that manually created ,some time it drop index that created by OS.


appreciate if someone has insight and can share some hint how OS manage database index.

 



I don't know if is it what you want, but did you already try create unique index in attribute do you want? 

look that: 

https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Data_Modeling/Create_an_Entity_Index