About Visual Explain
With this visual explain feature, you can run the query and show the output in a distributed environment. You can output the results in different formats. When queries are run, they make a scan through the database. The queries retrieve table metadata to fetch the correct output.
With this visual explain feature, you can visualize the query in a graphical representation. When a query is run in the SQL editor and selects the Explain option, watsonx.data uses an EXPLAIN SQL statement on the query to create a corresponding graph. This graph can be used to analyze, fix, and improve the efficiency of your queries saving time and cost.
- In the Query workspace page, enter the query and click Run on to get the results.
- Click Explain on the screen to visualize the graphical representation of the query.
On the Explain window, click a stage to view the details of that stage. The details of each stage that is displayed are the estimate values for rows, CPU, memory, and network.