Scenario
An SQL statement is not indexed and therefore can perform only full-table scans, resulting in low performance.
Case analysis
Example: An SQL statement for a business is not indexed, resulting in fluctuation of performance.
Optimization suggestions
SQL statement optimization: As shown in the following figure, the system prompts you to create an index on an appropriate field. In this example, you can create a normal index on the
(ID,NAME)field to avoid full-table scans.
Business process optimization: We recommend that you review SQL statements during code integration to prevent unindexed SQL statements from being published.
