Optimizing such a large table is very painful. According to your usage of data, if you don't query frequently, but increase frequently, you can consider copying the data in the table to the history table regularly (weekly or daily) and clearing the data in the worksheet, which will greatly improve the efficiency of insertion, but you need to query in two tables. Worksheets used for frequent data insertion should have as few indexes as possible, and historical tables used for queries should have more indexes.