In the wake of the performance issues with few of our BO reports ( based on Bex Queries) in production system, we have identified the need in adding few more secondary indexes (in addition to existing ones) on the underlying DSOs.
However, these secondary indexes have been directly created/added to the DSO Active tables in the Database( ) by our DBA team.
There was a significant improvement in the BO reports and all performance issues have been sorted out. We knew this is just a temporary fix and eventually, these indexes must be created in the DSOs and transported all the way to prod.
Now the concerns are,
Note: Our DBA team is speculating about deleting the indexes ( they are afraid as the deletion at table level may lead to inconsistencies to the entire DB or at least to those specific Active Tables)
Please let me know your thoughts.
BW Version : 7.0
Data base : DB6