Database Reference
In-Depth Information
Command
option
Description
> unset default_order_by_limit;
profile
Using this command, you can get low-level information on the last pro-
cessed query. You can use this command to fine-tune the query per-
formance by understanding the output of this command. The same
command can also be used for troubleshooting certain issues with the
query. The command is as follows:
> profile;
explain
This command is similar to the
EXPLAIN
query command to provide
an execution plan of a query. An example of using this command is as
follows:
> explain select * from studentlist;
Query: explain select * from
studentlist
Query finished, fetching results ...
+--------------------------------+
| Explain String |
+--------------------------------+
| PLAN FRAGMENT 0 |
| PARTITION: UNPARTITIONED |
| |
| 1:EXCHANGE |
| tuple ids: 0 |
| |
| PLAN FRAGMENT 1 |
| PARTITION: RANDOM |
