Skip to Content
0
Former Member
May 22, 2014 at 06:27 AM

Index on FEBEP - Negative impacts?

79 Views

Hi All,

After a performance analysis, we found that 80% of the database time was for the table FEBEP for one of our application. We have decided now to go forward for a secondary index on this table, since the application that we are talking about, is used constantly by multiple users on a daily basis. And the result of the addition of index has brought in quite considerable reduction in the time taken. (QA Test result )

Please let me know if creating this index would have a negative impact on any other transactions. I have searched for notes on this - couldn't find relevant ones, nor the where used list of the table is hinting any major issues. Please let me know if there are any transactions which I need to be watchful of, after creating this index. Or if at all any one has come across any problem after creating an index on FEBEP. Feedback much appreciated, and Thanks in advance.