PREVIEW SQL
Description
The PREVIEW SQL syntax is used to preview SQL execution plan.
Syntax
PreviewSql ::=
'PREVIEW' sqlStatement Return Value Description
| Column | Description |
|---|---|
| data_source_name | storage unit name |
| actual_sql | executed SQL statement |
Example
- Preview
SQLexecution plan
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)Reserved word
PREVIEW