Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / July 2008

Tip: Looking for answers? Try searching our database.

explain output for update statistics ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Joerg Rueschenschmidt - 15 Jul 2008 13:34 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.