Result of EXPLAIN query in IBM DataStudio

merik · #1 (**permalink**) 05-23-11, 16:01

I'm using IBM Data Studio in Ubuntu, and when I run a query like this:

Code:

EXPLAIN ALL FOR SELECT field FROM table;

All I get is this:

Code:

Run SQL

EXPLAIN ALL FOR SELECT field FROM table
Success
 
Query execution time => 23 ms
 
Total execution time => 23 ms

I don't see the actual result of EXPLAIN. What am I doing wrong?

sathyaram_s · #2 (**permalink**) 05-23-11, 21:10

AFAIK, this saved the expalain plan for the query in the explain tables.
Not sure how you view the saved explain plan in DataStudio.
In Control Centre, right clicking on the database name, there will be a menu item, 'show explain table history'. check if datastudio has something similar

hth

sathyaram

Peter.Vanroose · #3 (**permalink**) 05-24-11, 04:21

You could (and should) instead use the "Visual Explain" component of Data Studio.
First right click on the connection and select "enable Visual Explain".
This will create all necessary explain tables for you.
Then click on the "visual explain" toolbar to obtain a graphical representation of the explain output.