2 results about "Object function" patented technology

Disclosed in the embodiments of the present application are an execution plan analysis method and apparatus for structured query language (SQL), which method and apparatus are used for improving SQL execution plan analysis efficiency. The method in the embodiments of the present application comprises: a computing device determining an object function of a target database, wherein the object function comprises structured query language (SQL) statements that have been modified on the basis of restructuring logic, and the restructuring logic is used for identifying, in an execution plan, data manipulation language (DML) statements in the object function; the computing device generating an execution plan on the basis of the object function, wherein the execution plan is used for indicating performance evaluation metrics corresponding to one or more DML statements invoked in the object function; and the computing device displaying a performance analysis result corresponding to the execution plan, wherein the performance analysis result is used for identifying, from among the one or more DML statements, a DML statement the performance evaluation metric of which is lower than a threshold value.

Embodiments of the present application disclose a method and device for analyzing an execution plan of a structured query language (SQL), which are used for improving the analysis efficiency of the execution plan of the SQL. The method comprises the following steps: a computing device determines an object function of a target database, the object function comprising a structured query language (SQL) statement modified based on a reorganization logic, the reorganization logic being used for identifying a data manipulation language (DML) statement in the object function in an execution plan; the computing device generates an execution plan based on the object function, the execution plan being used for indicating a performance evaluation index corresponding to one or more DML statements in the object function; and the computing device displays a performance analysis result corresponding to the execution plan, the performance analysis result being used for identifying a DML statement whose performance evaluation index is lower than a threshold value in the one or more DML statements.