Commencer un nouveau sujet
Répondu

Index on semarchy table is blocking Semarchy deployment

When I create an index on xDM database tables to improve performance , but facing an error and unable to deploy the application due to this new index, How to resolve this?


Meilleure réponse
When deploying a model, it is the user of the repository who is used to deploy a model and each time he compares what is in the base in relation to the model to be deployed.
You need to prefix  your index with USR_ to ignore it when comparing, this will solve the issue


for example, a common way to do case-insensitive comparisons is to use the lower function:

SELECT * FROM test1 WHERE lower(col1) = 'value';


This query can use an index if one has been defined on the result of the lower(col1) function:

CREATE INDEX test1_lower_col1_idx ON test1 (lower(col1));  Now, in the above query you need to add USR_ as prefix in your index so that it does not throw an error  
CREATE INDEX USR_test1_lower_col1_idx ON test1 (lower(col1));


1 commentaire

Réponse
When deploying a model, it is the user of the repository who is used to deploy a model and each time he compares what is in the base in relation to the model to be deployed.
You need to prefix  your index with USR_ to ignore it when comparing, this will solve the issue


for example, a common way to do case-insensitive comparisons is to use the lower function:

SELECT * FROM test1 WHERE lower(col1) = 'value';


This query can use an index if one has been defined on the result of the lower(col1) function:

CREATE INDEX test1_lower_col1_idx ON test1 (lower(col1));  Now, in the above query you need to add USR_ as prefix in your index so that it does not throw an error  
CREATE INDEX USR_test1_lower_col1_idx ON test1 (lower(col1));


Connexion pour poster un commentaire