# Business Related Operations Investigation

+ The amount of data in the target table report_interact_detail corresponding to the SQL statement is constantly increasing, and the increment of the data in the table needs to be checked
```
SELECT id, report_dt, user_id, avatarpath, interact_type, reward_type_id, show_name, reward_name, city_name, create_time, update_time, version
FROM
  report_interact_detail
WHERE
  report_dt = ‘' AND reward_type_id = ''
ORDER BY
  winning_create_time DESC
LIMIT
  1;
```
+ Order by winning_create_time DESC is used in the SQL statement, and index scans use a single-column index on the create_time field
------------------------------------------------------------
- The amount of data in the target table report_interact_detail corresponding to Slow Query SQL is constantly increasing, and the increment of the data in the table needs to be checked
  - Order by winning_create_time DESC is used in SQL and index scans use a single-column index on the create_time field