Hi,
following document shows an example of an explain output for an update
statistics statement.
http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle/miller/
0203miller.html
I used following statement in dbaccess
set explain on;
update statistics for table x;
but no output is created in sqexplain.out file. The file is created but
it is empty.
I used IDS 11.50.FC1 on Linux.
Any idea how to turn on explain plan for update statistics ?
Regards ...
Joerg
Joerg Rueschenschmidt - 15 Jul 2008 19:02 GMT
Joerg Rueschenschmidt schrieb:
> Hi,
>
[quoted text clipped - 18 lines]
>
> Joerg
John Miller from IBM wrote to me. It works for distribution only.
You need to do update statistics medium or high to get the explain output.
Regards ...
Joerg