Oninit cdi / Archive
Talk to an expert →

explain output for update statistics ?

Posted in 2008

Topics: Performance & Tuning, Server Administration

Joerg Rueschenschmidt — — source: Usenet: comp.databases.informix

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

↪ replying to Joerg Rueschenschmidt
Joerg Rueschenschmidt — — source: Usenet: comp.databases.informix

Joerg Rueschenschmidt schrieb: > 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 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

Glossary