Skip to Content
Former Member
Aug 25, 2009 at 07:26 PM

No output from EXPLAIN



I want to use EXPLAIN for performance analysis of my SQL statements. But EXPLAIN does not print out anything, here's some sample output:

sqlcli MAXDB1=> explain select 1 from dual
2 rows affected (3992 usec)

That's all. Somewhere I read about a table named 'EXPLAIN' which EXPLAIN writes its results into, but also that table does not exist:

sqlcli MAXDB1=> select * from explain
* -4004: POS(15) Unknown table name:EXPLAIN SQLSTATE: 42000

I don't get it, what's wrong here? Do I have to install that EXPLAIN table manually (like in Oracle)? I did't find anything about that...