Recently we noticed executing any query on case table takes more than usual time. When we looked at the data, it looks like case table have millions of records against actual valid cases (It happens when ever we close our test plan, it logs underlying cases ).
–Total record/valid cases -:4973396/45150
By looking at the above number, we are little worried as once team start closing their plans, it might impact the UI as well. Please suggest how this can be handled to avoid any future impact?