Discover Informix - The data server with the most flexible cluster and replication technology on the market and the lowest TCO

Temporary tables

Again, this is another blog post about nothing new at all but an attempt to put down my understanding of temporary tables down in a way that will help me when I refer back to it and hopefully be of more wider use.

When looking at things like this a test system is always essential for checking things and finding some surprising results. If you don’t have one you can soon set one up with VMWare or Virtual Box and a copy of Informix Developer Edition. For this post I am going to set up a simple test instance with four specific dbspaces:

mholzbauer's picture

Are your statistics (distributions) are really up to date ? - PART II


So what we know in Part I  is that "Statistics updated." does not always mean that your statistics are up to date.
Sometimes it means: "Statistics are up to date and not changed - STATLEVEL threshold is not reached".

mholzbauer's picture

Are your statistics (distributions) are really up to date ? - PART I

or: Some more Secrets of "UPDATE STATISTICS"...
 

Did you sometimes wonder why a "UPDATE STATISTICS" Statement
is so faster in newer Informix version on greater tables ?

Or you wonder why the query is not faster after executed some
"update statistics medium/high" statements ?

akagel's picture

News from the IIUG

Here's a link to an announcement from the IIUG Board of Directors talking about this year's IIUG 2015 Conference celebrating the 20th Anniversary Year of the IIUG:

IIUG News March 20, 2015

Informix Warehouse Accelerator: Trickle Feed and NONEXCLTRIG

eherber's picture

Informix Newsletter Februar 2015

(german content)

Neue Ausgabe des IBM/Informix Newsletters

Im Newsletter-Archiv befindet sich die neueste Ausgabe des INFORMIX-Newsletters.

Inhaltsverzeichnis der Ausgabe:

fnunes's picture

IIUG Conference 2015 / Conferência IIUG 2015

Have you registered for the IIUG 2015 conference? (original version http://informix-technology.blogspot.com/2015/02/iiug-conference-2015-conferencia-iiug.html )

English version
IIUG is organizing its usual annual user conference. This year it will take place in the Mission Valley Marriott in San Diego, between 26-29 April.

aford's picture

Resolving In Place Alters - Part 4, The Slot Table

By the end of Resolving In Place Alters, Part 3 I was able to read the raw data pages that belong to the table with pending IPAs, but I wasn't able to see if a data page had a pending IPA or not. In this installment I will show you how I solved that problem using what I know about the Informix Data Page structure and the structure of my table before and after the in place alter was performed.

Anatomy of the Informix Data Page

fnunes's picture

Informix on Pi / Informix no Pi

IBM finally released the Pi version (original version here: http://informix-technology.blogspot.com/2015/01/informix-on-pi-informix-no-pi.html)

English version

eherber's picture

Informix Newsletter Januar 2015

(german content)

Neue Ausgabe des IBM/Informix Newsletters

Im Newsletter-Archiv befindet sich die neueste Ausgabe des INFORMIX-Newsletters.

Inhaltsverzeichnis der Ausgabe: