Sometime when you load data, we are not able to get fast access using application. In order to fix this do following:-
ALTER INDEX ALL ON TBL_PlanBUDGET REBUILD WITH (ONLINE = ON, SORT_IN_TEMPDB = ON, FILLFACTOR = 80)
Update STATISTICS TBL_PlanBUDGET
No comments:
Post a Comment