Hi!
I wonder what the recommendations/guidelines is considering adding new indexes on the tables in the AVDB database schema?
I have a customer that is considering this to speed up some SQL queries for a costume made JSP.
Can this affect the application in some other way?
Is it recommended to not do this or can we proceed with doing it?
This is not recommended. You may see short-term gain but may result in painful migration and upgrade to later releases of the product. If the same index is later added as part of the migration, this will cause a migration failure. If you are having a performance issue in regards to application functionality, I suggest you open a support case with RSA.
Ok then we will avoid this!
Thanks for the answer!
This is not recommended. You may see short-term gain but may result in painful migration and upgrade to later releases of the product. If the same index is later added as part of the migration, this will cause a migration failure. If you are having a performance issue in regards to application functionality, I suggest you open a support case with RSA.