# Large Amount Of Keys Scan Case Study (A)

+ A large table: report_interact_detail
  + The business logic on report_interact_detail table is insert on duplicate, and the overall trend is to be appended continuously


------------------------------------------------------------

Read the visualization of TiDB Dashborad traffic, the monitoring of PD is basically confirmed. Next, let's continue to troubleshoot the problem that a large number of keys were scanned during the SQL query. We can corroborate this speculation in the following ways:
- Confirm the data increment of the target table report_interact_detail with the business party
  - Feedback from the business side, the data writing logic of this table is insert on duplicate, and the overall trend is that data will be appended continuously