Im testing an ecommerce application, which is connected to oracle database.
Currently, DBA has done oracle rebuild index.
What to test on application end, when oracle rebuilding index is done on database?
Hello Srinivas!
In theory, an index rebuild has no impact on the application using it. However, since the database is likely to provide data that must be displayed, I recommend a set of tests the focus on areas in the application where there is database/application interaction. This will help verify that the connections between what is displayed where and the database are still correct.
Indexing, in my experience, is used to help performance of a database. Perhaps you might consider a performance evaluation (a performance test or stress test) through the application.
Joe
4 Likes
Thanks Joe for your suggestions.
I looked into the area on application end connecting with database. not on performance evaluation (test) end.