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...