Index only affect one day!
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.