Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Index only affect one day!

Hello,

As the search on one table cost too much time, I added an index. That day the speed did get improved significantly but the next day it slow down again.

The status of the index(via Se11 -> <table_name> -> index) is active and exist in database system Oracle. I tried it again and got the same result.(index only affect one day).

Why does this happen?

Many thanks in advance.

BR,

Former Member
Not what you were looking for? View more on this topic or Ask a question