# Large Amount Of Keys Scan Case Study (C)

+ Analysis conclusion:
  + SQL statements in Slow Query scan a large number of keys have a direct relationship with the increment of target table data
  + GPRC coprocessor duration and number of keys are positively correlated in monitoring TikV-Details
+ The solution:
  + SQL statement optimization

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

A large number of keys scanned by SQL in Slow Query are directly related to the increment of target table data, and reflected in the monitoring of TikV-Details, it can be seen that the GPRC coprocessor duration and the number of keys are positively correlated