How to interpret sqexplain.out

Posted in 2000

Ross Berman — Wed, 06 Sep 2000 04:37:40 GMT — source: Informix-list mailing list archive (1991-1998)

I've got the basics on how to interpret an sqexplain file from the Informix Performance Guide but does anyone know about a more comprehensive resource or advanced guide to understanding the output from SET EXPLAIN ON? Thanks, Ross

↪ replying to Ross Berman

Doug Agnew — Wed, 6 Sep 2000 09:40:32 -0400 — source: Informix-list mailing list archive (1991-1998)

I'm not aware of any more comprehensive resource, other than the pooled intelligence of this group (and that may be a stretch). Maybe you should post some of the items that are confusing/unclear and see what the other wonderful folk here can contribute...... Doug "Ross Berman" <rdberman@yahoo.com> wrote in message news:39B5CAA3.4194DBB3@yahoo.com... > I've got the basics on how to interpret an sqexplain file from the > Informix Performance Guide but does anyone know about a more > comprehensive resource or advanced guide to understanding the output > from SET EXPLAIN ON? > > Thanks, > > Ross >

↪ replying to Ross Berman

Christian Knappke — Wed, 6 Sep 2000 18:01:17 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi Ross, look at the "Performance Guide". If you can't find it on your bookshelf get it from http://www.informix.com/answers/ HTH -- Christian "Ross Berman" <rdberman@yahoo.com> wrote in message news:39B5CAA3.4194DBB3@yahoo.com... I've got the basics on how to interpret an sqexplain file from the Informix Performance Guide but does anyone know about a more comprehensive resource or advanced guide to understanding the output from SET EXPLAIN ON? Thanks, Ross