HomeMogDBMogDB StackUqbar
v5.0

Documentation:v5.0

Supported Versions:

Other Versions:

Overview

SQL Rewriter is an SQL rewriting tool. It converts query statements into more efficient or standard forms based on preset rules to improve query efficiency.

img NOTE:

  • This function does not apply to statements that contain subqueries.
  • This function supports only the SELECT and DELETE statements for deleting the entire table.
  • This function contains 11 rewriting rules. Statements that do not comply with the rewriting rules are not processed.
  • This function displays original query statements and rewritten statements on the screen. You are not advised to rewrite SQL statements that contain sensitive information.
  • The rule for converting UNION to UNION ALL avoids deduplication and improves the query performance. The obtained result may be redundant.
  • If a statement contains ORDER BY + specified column name or GROUP BY + specified column name, the SelfJoin rule is not applicable.
  • The tool does not ensure equivalent conversion of query statements. The purpose is to improve the efficiency of query statements.
Copyright © 2011-2024 www.enmotech.com All rights reserved.