queries are very slow

[pritesh jha]

we've added a custom field to an entity, and are doing GETs using that field as the condition. These queries are very slow, and I suspect it is because the custom field is not indexed. Is there any problems with adding an index manually to the database to improve the performance of the query? Will this affect my ability of upgrading the ESPO application later on if I have those custom indexes?

[a.slyzhko]

After every rebuild, all indexes added by your approach will be dropped. You can add indexes using method explained here

[pritesh jha]

what is the mean by rebuild? is update?