PREVIEW SQL 语法用于预览 SQL 执行计划。
PreviewSql ::=
'PREVIEW' sqlStatement
| 列 | 说明 |
|---|---|
| data_source_name | 存储单元名称 |
| actual_sql | 实际执行 SQL 语句 |
SQL 执行计划PREVIEW SELECT * FROM t_order;
mysql> PREVIEW SELECT * FROM t_order;
+------------------+-----------------------+
| data_source_name | actual_sql |
+------------------+-----------------------+
| su_1 | SELECT * FROM t_order |
+------------------+-----------------------+
1 row in set (0.18 sec)
PREVIEW