(DI-2308) Cleanup Extended Query Statistics
You can use the report /DVD/QS_DELETE or transaction /DVD/QS_DEL for cleanup of extended query statistics that are collected in tables /DVD/QS_INFO and /DVD/QS_QVAR.
Scheduling cleanup
If you want to clean up statistics regularly, you need to create a dynamic variant for the report /DVD/QS_DELETE as follows.
- Open transaction SE38 and type report name
- Click on button
- Chose new variant name and click on the button
- Click on button
- Create variable for field Date
- Press F4 on Selection variable column for Date filed and choose which date (System Date or Local Date) should be used for dynamic calculation and confirm
- Press F4 on Name of Variable column for Date filed and choose the select option that should be used for execution. In our case, we chose everything less or equal than the current day minus ??? days and confirm
- Now choose how many days should be subtracted from the current day and confirm
- Save variant
- Use created variant and schedule job that will be running on a regular basis
- Press F4 on Selection variable column for Date filed and choose which date (System Date or Local Date) should be used for dynamic calculation and confirm